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

["Pink, Michael" <Michael.Pink@pgnmail.com>]

If you add the date with a single quote ' on both sides it should treat
the field as text and not format it.

-----Original Message-----
From: sqr-users-bounces+michael.pink=pgnmail.com@sqrug.org
[mailto:sqr-users-bounces+michael.pink=pgnmail.com@sqrug.org] On Behalf
Of Darshil Mehta
Sent: Thursday, July 08, 2004 6:18 AM
To: This list is for discussion about the SQR database reporting
languagefrom Hyperion Solutions.
Cc: sqr-users@sqrug.org;
sqr-users-bounces+darshil.mehta=lntinfotech.com@sqrug.org
Subject: Re: [sqr-users] Problem with Date Format in .csv


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

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