Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

date convert 1

Status
Not open for further replies.
Abslag

Abslag

Technical User
Mar 24, 2005
42
US
I have a field that contains date/time info but I need to convert it to a legible date time format. It is formatted like '20051206135428' and I would like for it to read 12-06-2005 01:54.28 pm (mm-dd-yyyy hh:mi:ss) or I could even drop the time and say mm-dd-yyyy. Whichever is simpler. Any comments would be appreciated.
 
Sort by date Sort by votes
Use To_Char(To_Date('20051206135428','YYYYDDMMHH24MISS'),'DD-MM-YYYY HH:MI:SS pm')
 
Upvote 0 Downvote
Oops, the date formats should be 'YYYYMMDDHH24MISS' and 'MM-DD-YYYY HH:MI:SS pm'.
 
Upvote 0 Downvote
Lewisp,
I knew it was simple, but it had me going in circles. Thanks a ton.
[rockband]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
2K
carp
carp
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
321
SkipVought
S
EM1107
  • Locked
  • Question
How to convert CLOB data into number and compare it to other table.
Replies
4
Views
395
carp
carp
EM1107
  • Locked
  • Question
Insert date and time using UTC time in a DATE column
Replies
14
Views
582
EM1107
EM1107
kernal
  • Locked
  • Question
If Day of the Week='Y' (i.e. Mon='Y') and between a Start Date and End Date then Count #of Days 1
Replies
1
Views
100
Beilstwh
Beilstwh

Part and Inventory Search

Sponsor

Back
Top