Formatting a date

[MoaD]

Ok i have a table which stores a date in the medium format
( i.e. 04-Apr-02 )

but when i write it to a page asp shows it as 04/04/02?
heres my code

<%=dbExecSQL( 0 )%>

that is the date from the table
i want the date to show in medium format 04-Apr-02
any help is appreciated

 

[Dynapen]

What database are you using? In SQL Server you can use a convert command, but the syntax is different from that in MS Access, which is what is sounds like you are using. The money's gone, the brain is shot.....but the liquor we still got.

 

[MoaD]

its ok i figured it out

i just changed the field format from date to text

Thanks anyway all