RE: [sqr-users] String to Date format

["Ven Garlapati" <VXG@creditacceptance.com>]

Eric:

If I read your message right, you are trying to convert a string to date 
format?  In Oracle you can use like:
select  to_date ('06/05/2003 01:03:00','dd/mm/yyyy HH:MI:SS') from dual;  I got 
the answer as:  6-May-2003 1:03:00.
If this is right, you can incorporate same logic!!

Thanks,
Ven Garlapati 
vxg@creditacceptance.com
(248) 353-2700 ext.514


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


Thanks for the quick responses

"SQR in Peoplesoft" has been of little help. The string looks like a date in 
the table I reference, but is not 
in fact a DATE. Therefore, I can't use datediff() to return a value. So I'm 
trying to basically keep the string as it
is, but as a date instead of a string. Convert this into a date of the same 
format(String = 01/01/2001 01:15:00). 

Eric

-----Original Message-----
From: Knapp, Richard [mailto:KnappR@umsystem.edu]
Sent: Wednesday, October 01, 2003 2:37 PM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] String to Date format



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

_______________________________________________
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