RE: [sqr-users] Sysdate

["Shibu Joys" <finsj@langate.gsu.edu>]

You can also try using
WHERE
to_char(a.audit_stamp,'DD-MON-YYYY') = TO_CHAR(SYSDATE,'DD-MON-YYYY')


>>> radhika_05@hotmail.com 09/13/05 2:19 PM >>>

Thank you Jim and Penny. It worked. I am on Oracle.

Radhika

>From: "Jim Womeldorf" <jwomeldo@fastenal.com>
>Reply-To: "This list is for discussion about the SQR database 
>reportinglanguage from Hyperion Solutions." <sqr-users@sqrug.org>
>To: "This list is for discussion about the SQR database reporting 
>languagefrom Hyperion Solutions." <sqr-users@sqrug.org>
>Subject: RE: [sqr-users] Sysdate
>Date: Tue, 13 Sep 2005 09:29:47 -0500
>
>Hi Radhika,
>
>If you are on Oracle try using trunc()
>
>where trunc(a.audit_stamp) = trunc(sysdate
>
>Jim
>
>-----Original Message-----
>From: sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org 
>[mailto:sqr-users-bounces+jwomeldo=fastenal.com@sqrug.org] On Behalf Of
>radhika reddy
>Sent: Tuesday, September 13, 2005 9:04 AM
>To: sqr-users@sqrug.org 
>Subject: [sqr-users] Sysdate
>
>Hi,
>
>    I am trying to retrieve rows which are equal to sysdate. The date
>field stored on ps_audit_addresses is in the format of date
>time(9/13/2005 8:45:33 AM). By doing the following I am able to achieve
>it. But, i am wondering is there any other way where instead of getting
>all the rows from PS_AUDIT_ADDRESSES and then checking whether Audit
>Stamp is equal to SYSDATE?
>See, i tried using SUBSTR in sql but it didn't work.
>
>
>begin-select
>a.emplid,
>a.audit_stamp &timestamp
>
>    display $sysdatetime            !here i get 13-SEP-2005_09:50:49_AM
>
>    let $sysdate1 = substr($sysdatetime,1,11)
>    #debugH show $sysdate1                               !13-SEP-2005
>
>    show 'timestamp:' &timestamp                         !13-SEP-2005
>
>   If $auditimestamp = $sysdate1
>      show 'transaction on that date'                      !both are
>equal
>   else
>      show 'no transactions'
>   end-if
>
>from ps_audit_addresses a
>!where substr(a.audit_stamp,1,11) = SYSDATE END-SELECT
>
>Thanks,
>Radhika
>
>_________________________________________________________________
>On the road to retirement? Check out MSN Life Events for advice on how
>to get there! http://lifeevents.msn.com/category.aspx?cid=Retirement 
>
>
>_______________________________________________
>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 

_________________________________________________________________
Don't just search. Find. Check out the new MSN Search! 
http://search.msn.click-url.com/go/onm00200636ave/direct/01/ 





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