Java bro

Java tutorial

Sql queries

Convert varchar date to sql date

Using TO_DATE oracle function we can convert string date to sql date . See the following syntax.

Syntax:

SELECT TO_DATE(‘STRING DATE’ , ‘STRING DATE FORMAT’) AS SYS_DATE FROM DUAL;
Example:

SELECT TO_DATE(’01/08/2015′ , ‘DD/MM/YYYY’) from DUAL;


Output :

SYSDATE
01-AUG-15


See the above exmaple , two parameters passed to TO_DATE function . First parameter is string date that we want to convert . Second parameter is the date format of string .
For example , if our string date is ‘January 13 2015’ then date format that should be passed to TO_DATE function is ‘MONTH DD YYYY’ .
Some date formats

FORMAT DESSCRIPTION
DD Represents day number in a month.
DDD Represents day number in a year[1-366] (for exmaple :091)
D Gives day number in a week[1-7]
DAY Gives day name Ex : sunday
FMDAY Gives day name without trailing spaces
MM Gives month number
MON Gives First three letters of month . Ex :FEB
MONTH Gives complete month name with trailing spaces.
FMMONTH Gives complete month without trailing spaces.
YY Gives last two digits of year
YYYY Gives year number.
YEAR Gives year in word format. Ex: TWENTY SIXTEEN

Comments are Closed

Theme by Anders Norén