[sqr-users] Problem with Date Format in .csv

[vaibhav_jindal@non.agilent.com]

Hi 
 
 
I am having some problem in the date formats.The problem is that in the main 
query iam converting the date in mm/dd/yy hh:mm:ss AM format like this :
TO_CHAR(ooha.ordered_date, 'mm/dd/yy HH:MM:SS AM') &ORDERED_DATE (15,3500)
 
and while creating the csv , iam giving : 
let $brb_csv_data = $brb_csv_data || ',' || '"' || &ORDERED_DATE  || '"'
 
as a result, in the html result file .. iam getting the date in the correct 
format eg : 2/12/02 01:20:03 AM 
but in the csv that is generated .. it is automatically  converting the time 
into 24 hour format :  
3/19/2003 13:03 
 
 
What I want is that the date in csv format should also come the same as in the 
html format.
Can someone suggest some alternative.....
 

Thanks & Regards

Vaibhav Gupta
Business Intelligence and Enterprise Reporting
TCS @ Agilent Technologies

  

 

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