RE: [sqr-users] Date Format Help

[James Womeldorf <jwomeldo@fastenal.com>]

Try this:
select trunc(sysdate) from dual

Jim Womeldorf

-----Original Message-----
From: Miller, Danika [mailto:MillerD2@ndu.edu]
Sent: Friday, May 14, 2004 9:45 AM
To: 'sqr-users@sqrug.org'
Subject: [sqr-users] Date Format Help


Ok, this should be an easy one, but it's Friday and my brain is totally
fried.

Anywho...

I'm selecting END_DT via Toad and return the following date format:
5/14/2004
When my SQR runs I want to select rows where END_DT >= SYSDATE
When I select SYSDATE from DUAL, I get:  5/14/2004 10:39:26 AM

Now, I know that I need to do some type of formatting within my program, but
what is it?  I've tried adding:

begin-select
END_DT
        let $end_dt =   to_date(end_dt,'DD-MON-YYYY:HH:MI:SS')
from ps_table 
end-select

But that didn't work.  Am I even close to getting this right???
FYI, we are currently running Oracle 9i.

PLEASE HELP!!!




_______________________________________________
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