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

["the dragon" <ceprn@hotmail.com>]

Vaibhav,

Is the date correct in the .csv, when you view it with a **> TEXT EDITOR <** 
???  If it is, then MicroShaft excel is doing something to convert it when 
it reads the .csv file.

peace,
clark 'the dragon' willis



PSA: Salary <> Slavery.  If you earn a salary, your employer is renting your 
services for 40 hours a week, not purchasing your soul.  Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent.  Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)

----Original Message Follows----

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



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