cast from datetime type to smalldatetime type?

  • Thread starter Thread starter Salim Afþar
  • Start date Start date
S

Salim Afþar

Hi,
How can I cast from datetime type to smalldatetime type.
I get the records from a table which has got a datetime type column but I
want to display it smalldatetime format.
Thanks,
Salim
 
I think you can use something like:

response.write(dMyLongDate.tostring("dd/MM/yy"))

Regards,

Stu
 
Not like that:
I get it with sql string.I want to do something like that :

select format(mydate,("dd/MM/yy"),.... from myTable

Thanks a lot
 
Back
Top