top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

+1 vote
336 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 LinkedIn 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
...