date to string type

[mehmetned]

How to create a query to convert a date datatype to string datatype? I use Ms access database.

[mcmcom]

select cast(myDate as varchar) as my_new_column_name.

should work

hth,
mcm

[davide++]

Hi all

Use Format$ function

select Format$(DateFiled, 'dd/mm/yyyy') as DATA_CHAR from MYTABLE