cast from datetime type to smalldatetime type?

[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

[Stu]

I think you can use something like:

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

Regards,

Stu


"Salim Afþar" <safsar@luckyeye.com> wrote in message
news:%231j6NMDWDHA.2228@TK2MSFTNGP12.phx.gbl...

> 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
>
>

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system ([url]http://www.grisoft.com[/url]).
Version: 6.0.505 / Virus Database: 302 - Release Date: 30/07/2003

[Salim Afþar]

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

"Stu" <stuart@ntpcl.uk.com> wrote in message
news:u2I$BVDWDHA.1352@TK2MSFTNGP10.phx.gbl...

> I think you can use something like:
>
> response.write(dMyLongDate.tostring("dd/MM/yy"))
>
> Regards,
>
> Stu
>
>
> "Salim Afþar" <safsar@luckyeye.com> wrote in message
> news:%231j6NMDWDHA.2228@TK2MSFTNGP12.phx.gbl...

> > 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
> >
> >

>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system ([url]http://www.grisoft.com[/url]).
> Version: 6.0.505 / Virus Database: 302 - Release Date: 30/07/2003
>
>