RE: [sqr-users] Date Format Help

["Chu, Nicholas" <Nicholas.Chu@RedPrairie.com>]

oops, i meant using TO_CHAR!!!

-----Original Message-----
From: sqr-users-bounces+nicholas.chu=redprairie.com@sqrug.org
[mailto:sqr-users-bounces+nicholas.chu=redprairie.com@sqrug.org]On
Behalf Of Chu, Nicholas
Sent: Friday, May 14, 2004 9:50 AM
To: 'This list is for discussion about the SQR database reporting
language from Hyperion Solutions.'
Subject: RE: [sqr-users] Date Format Help


can you do this?

begin-select
to_date(END_DT, 'DD-MON-YYYY:HH:MI:SS') &end_dt
  (move &end_dt to $end_dt if you want to)
from ps_table 
end-select

nicholas

-----Original Message-----
From: sqr-users-bounces+nicholas.chu=redprairie.com@sqrug.org
[mailto:sqr-users-bounces+nicholas.chu=redprairie.com@sqrug.org]On
Behalf Of Miller, Danika
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

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