Convert string field to date via sql

gabeshackle · Feb 4, 2002

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.

biosraman · Feb 8, 2002

Dear gabeshackle,

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

May 25, 2002

To use a SUM-Operation in a query it is necessary for me to convert the attribute from data type "char" to another (integer).

How is the syntax for this conversion (convert(char,??)

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Convert string field to date via sql

gabeshackle

Computer

biosraman

New member

Guest

Similar threads

Part and Inventory Search

Sponsor