Home » SQL & PL/SQL » SQL & PL/SQL » date format as dd/mm/yyyy in the excel
date format as dd/mm/yyyy in the excel [message #617013] Tue, 24 June 2014 03:40 Go to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Hi all,

I have used sysdate for one column in the select and i need the date format as dd/mm/yyyy when i save into the excel file.In the excel sheet the date format shown as dd-mon-yy

The data retrieved into the excel file using UTL_FILE's

Thanks,
Siva
Re: date format as dd/mm/yyyy in the excel [message #617016 is a reply to message #617013] Tue, 24 June 2014 03:51 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
To_char the date to get it in the correct format and wrap it in "" to stop excel from reformatting it.
Re: date format as dd/mm/yyyy in the excel [message #617017 is a reply to message #617013] Tue, 24 June 2014 03:51 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So use the proper format in TO_CHAR function.

Re: date format as dd/mm/yyyy in the excel [message #617019 is a reply to message #617013] Tue, 24 June 2014 03:59 Go to previous message
Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web
Senior Member
mist598 wrote on Tue, 24 June 2014 14:10

In the excel sheet the date format shown as dd-mon-yy


How is this question related to Oracle in anyway? Look at Format a date the way you want in Excel
Previous Topic: can we use 'Select' in IF statement
Next Topic: Arabic letters not displayed in xmltype table
Goto Forum:
  


Current Time: Fri Mar 29 06:26:23 CDT 2024