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

Facebook Login
Site Registration

How can we convert a date to char in Oracle Please explain with Example

+1 vote
45 views
How can we convert a date to char in Oracle Please explain with Example
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

The best answer is:
to_ date function is used to convert string to a date function.

Syntax :  to_date(string, format)
Example:   to_date('2014/05/10', 'yyyy/mm/dd')  It will return May 10, 2014
answer May 10, 2014 by Amit Kumar Pandey
0 votes

Date Format:

SELECT GETDATE()

It will show the output 2014-11-17 15:26:19.580

Convert Date to Char:

  SELECT CONVERT(VARCHAR(15),GETDATE(),103)

It will show the output 17/11/2014

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
...