top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

How we can convert string to a date in oracle database?

+1 vote
44 views
How we can convert string to a date in oracle database?
posted May 5, 2014 by Avinash Shukla

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

2 Answers

0 votes

AFAIK There is no DATETIME format in Oracle and you can use TO_DATE(date_col, 'YYYY-MM-DD HH24:MI:SS AM') or something similar to convert a string to date.

Example

TO_DATE('2011-07-28T23:54:14Z',  'YYYY-MM-DD"T"HH24:MI:SS"Z"')
answer May 6, 2014 by Salil Agrawal
0 votes
SELECT CONVERT(DATE,'17/11/2014',103)
answer Nov 17, 2014 by Manikandan J
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...