RE: [sqr-users] date format

["Jon Alsager" <Jalsager@ISIF.STATE.ID.US>]

Maybe try this:

let $activity_date = strtodate($activity_date, 'YYYYMMDD')

Jon

-----Original Message-----
From: sqr-users-bounces+jalsager=isif.state.id.us@sqrug.org
[mailto:sqr-users-bounces+jalsager=isif.state.id.us@sqrug.org] On Behalf
Of radhika reddy
Sent: Tuesday, May 10, 2005 9:02 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] date format

Hi,

   I always have tough time to format dates. This time the date that I
get 
from a flat file is in 'YYYYMMDD' format. However i do it i get errors.

I tried doing something like this:-

Let $activity_date = edit($activity_date, 'dd-mon-yyyy')

or

let $activity_date = to_char(to_date($activity_date, 'YYYYMMDD'), 
'dd-MON-yyyy')
and

let $activity_date = 
Datetostr(StrtoDate($activity_date,'YYYYMMDD'),'dd-MON-yyyy')

and

begin-select on-error=print-date-error
to_char(to_date($activity_date, 'MM/DD/YYYY'), 'dd-MON-yyyy')
&activitydate
  move &activitydate to $activity_date
from dual

Any idea where i am going wrong on this?

Thanks.

_________________________________________________________________
Is your PC infected? Get a FREE online computer virus scan from
McAfee(r) 
Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963


_______________________________________________
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