RE: [sqr-users] String to Date format

["Knapp, Richard" <KnappR@umsystem.edu>]

I'm guessing the the date part is month/day so the format string for your 
example would be:

    'MM/DD/YYYY HH:MI:SS'

Do you not have access to any SQR documentation?

Richard Knapp
Database Programmer/Analyst
Institutional Research and Planning
University of Missouri System
573-882-8856
knappr@umsystem.edu


-----Original Message-----
From: Ottaway, Eric (PS, GNF, Contractor) [mailto:Eric.Ottaway@gnf.com]
Sent: Wednesday, October 01, 2003 1:09 PM
To: 'sqr-users@sqrug.org'
Subject: [sqr-users] String to Date format


Hey guys and gals,

I'm still having trouble trying to format a string ('06/05/2003 01:03:00) into 
a date with the same format. Anyone have any ideas on how to do this? I've 
tried using a to_date function and a strtodate function. Both failed.

Thanks,

Eric B. Ottaway

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users