RE: [sqr-users] date format

["Lindquist, Maria" <mlindqui@uwc.edu>]

Did you try the following at all? 

Let $Activity_Date = TO_DATE($Activity_date,'dd-mon-yyyy') 

Maria

-----Original Message-----
From: sqr-users-bounces+mlindqui=uwc.edu@sqrug.org
[mailto:sqr-users-bounces+mlindqui=uwc.edu@sqrug.org] On Behalf Of
radhika reddy
Sent: Tuesday, May 10, 2005 10: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