![]() ![]() I tried variations on use to_number to_char and interpreters, all nothing will do. This is probably a simple question, but I can't seem to find the answer. How to compare a column with the text of a column with numbers If this isn't the case, run select with the to_char two as separate columns to see that get us the data that we expect. ![]() This should telll Oracle to the format of the generated string. Sorry, we need a new format around the to_date select to_date(to_char(chgdate, 'mm/dd/yyyy') || ' ' || to_char(chgtime, 'hh24:mi:ss'), 'mm/dd/yyyy hh24:mi:ss') from etime3 ![]() You will need to update the CHGDATE column with the time of the CHGTIME column. Please help me find the query to create a table with 3 columns and insert the following dataĤ214984 | 2 OCTOBER 06 12.00 AM | 07:23:57Īnd update of the first line of the above table as followsĤ214984 | 2 OCTOBER 06 07.00 AM | 07:23:57 Help me create a column with the time format ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |