[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
[sqr-users] Date Format Help
- Subject: [sqr-users] Date Format Help
- From: "Miller, Danika" <MillerD2@ndu.edu>
- Date: Fri, 14 May 2004 10:45:20 -0400
- Delivery-date: Fri, 14 May 2004 09:47:06 -0500
- List-id: "This list is for discussion about the SQR database reportinglanguage from Hyperion Solutions." <sqr-users.sqrug.org>
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