RETREIVING DATE DATATYPES

[PAULBOS]

What is the correct sql syntax for retreiving a date column from a table in character format ? Any assistance will be greatly appreciated.

 

[bteq]

This might help

select date_column (FORMAT 'yyyymmdd') (char(08))
from table_name

 

[titio]

i hava another question :

What is the correct sql syntax for retreiving a character month column like 'YYYYMM' from a date ?

i try :
SUBSTRING ( EXTRACT YEAR from date || EXTRACT MONTH from date 1 for 6 ) ????????????