Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Change the Date Format Expand / Collapse
Author
Message
Posted Wednesday, March 20, 2013 2:36 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, December 31, 2013 3:28 AM
Points: 13, Visits: 43
Good evening,
Please, my sql server Database has a table which contains this field: Date_Start(Datetime, Null). The format of the data in the table is yyyy/mm/dd. I have tried to export this table in Excel through SIS. Although I have used this fonction Convert(Date,Date_Start,103) the date format is still yyyy/mm/dd instead of dd/mm/yyyy in my Excel File. please what can I do to obtain the correct date format dd/mm/aaaa in my excel file after data exportation from my table through SIS?
Thanks in advance.
Post #1433491
Posted Wednesday, March 20, 2013 2:46 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: 2 days ago @ 4:49 PM
Points: 866, Visits: 7,478
Converting a date back to a date will end up displaying the date in the same default format.

Try:
Convert(varchar(20),Date_Start,103)





And then again, I might be wrong ...
David Webb
Post #1433498
Posted Thursday, March 21, 2013 2:48 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, December 31, 2013 3:28 AM
Points: 13, Visits: 43
It's Ok now. Thank you.
Post #1433638
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse