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

["Darshil Mehta" <Darshil.Mehta@lntinfotech.com>]

Vaibhav,

I guess it has nothing to do with your code. This is excel limitation that 
excel changes the date format according to excel's own setting.

Cheers

Darshil





vaibhav_jindal@non.agilent.com
Sent by: sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org
08/07/2004 03:33 PM
Please respond to "This list is for discussion about the SQR database 
reporting       language from Hyperion Solutions."

 
        To:     sqr-users@sqrug.org
        cc: 
        Subject:        [sqr-users] Problem with Date Format in .csv


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

______________________________________________________________________




______________________________________________________________________

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