Date convert problem
451680Aug 29 2005 — edited Aug 30 2005Hi,
I have a column with varchar datatype to store the date. The data looks like "7/23/2005", "9/1/2005" etc. I want to do convert another column with date datatype in other table to a format like this in order to do the query. But a problem arises when I do this:
In conversion from other date column to_char(date_column, 'MM/DD/YYYY'). The end results are "07/23/2005", "09/01/2004" and don't exactly match date_column_varchar as I mentioned above.
Is there any date format I can use to do this? I don't want to convert varchar date column to date because I want to use index on the varchar date column.
Thanks
Acton