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

[Dattatraya Shetty <datta_shetty@yahoo.com>]

Vaibhav,
    Did you Check the CSV in other Editors Like Notepad or some thing?
or in unix? 

    Check and see if the Format is being messed up by EXCEL Cell
formating, if so then Mike's Suggestion is good create a Text value to
retain the Date format.

HTH 
Datta. 
--- "Pink, Michael" <Michael.Pink@pgnmail.com> wrote:
> 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
> 



        
                
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail 

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