[sqr-users] date format

["radhika reddy" <radhika_05@hotmail.com>]

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Ž 
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