Convert input type Date to String for SQL

[gonpla]

Hello,
In my database I have a date field of type string, for example 20111025. I have an input field of type date and want convert to string for sql query.
Could anyone help me? Thank you.

Rubén.

[pioppogatto]

You can use to_char and to_date SQL function to convert and manage date and string

 

TO_CHAR: Given a date ex. of 27/02/97, returns '27-FEB-97'

TO_DATE: Converts a Char date to a Date data type.

 

Examples:

 

select TO_DATE(20111025, 'YYYYMMDD') AS DATE from dual

returns 25/10/2011

 

or

 

select to_char(TO_DATE(20111025, 'YYYYMMDD'), 'YYYY') AS YEAR from dual

returns only the year 2011