OraFAQ Forum: SQL & PL/SQL » Date format help

Home » SQL & PL/SQL » SQL & PL/SQL » Date format help (oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Date format help [message #638939]

Thu, 25 June 2015 20:55

gorants
Messages: 85
Registered: May 2014
Location: ATL

Member

Hello All,

How you doing. i need help to convert the below date format. appreciate your inputs.

I need to convert 28-APR-15 11.25.54.000000000 AM to MMDDYYYYHHMMSS how to do.

Thanks

Report message to a moderator

Re: Date format help [message #638940 is a reply to message #638939]

Thu, 25 June 2015 21:03

John Watson
Messages: 9003
Registered: January 2010
Location: Global Village

Senior Member

You need to research the TO_CHAR function. For example,

orclz> select to_char(systimestamp,'MMDDYYYYHHMMSS') from dual;

TO_CHAR(SYSTIM
--------------
06262015030621

orclz>

Report message to a moderator

Re: Date format help [message #638941 is a reply to message #638939]

Fri, 26 June 2015 00:55

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

I need to convert

Is the input of VARCHAR2 or of TIMESTAMP datatype?

Report message to a moderator

Re: Date format help [message #638947 is a reply to message #638939]

Fri, 26 June 2015 06:56

EdStevens
Messages: 1377
Registered: September 2013

Senior Member

see: - But I want to store my date as ...

Report message to a moderator

Previous Topic:	Update Join..
Next Topic:	default value on update in oracle 11G

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 27 05:27:48 CDT 2026