Convert string field to date via sql
Convert string field to date via sql
(OP)
I have a data field that is a type text in an existing database containing dates in the format mm/dd/yyyy and I'm trying to order the records by that field as a date. Is there anyway to convert this field to a date within the sql statement and then base the order off of that? Thanks.
RE: Convert string field to date via sql
I am not sure of the database you are using, but most of the database has function to convert one datatype to another. like to_date() in oracle, format() in Access. If the information are not sufficient please feel free to mail me at simp_raman@rediffmail.com , meanwhile update the information here for the benifit of other members.
With regards,
Raman
RE: Convert string field to date via sql
How is the syntax for this conversion (convert(char,??)