date format transfer

Hi,
My data type of date field is smallint,
I select it and get 2004-08-16 00:00:00:000
How could I modify it as 93/08/16 (Chinese year)
(93 is Chiense year, 2004 - 1911 = 93)
Thanks!
AngiSELECT CONVERT(CHAR(8), DATEADD(YEAR, -11, column), 11) FROM table
http://www.aspfaq.com/
(Reverse address to reply.)
"Angi" <angi@.microsoft.com> wrote in message
news:O6NtrG6gEHA.3016@.tk2msftngp13.phx.gbl...
> Hi,
> My data type of date field is smallint,
> I select it and get 2004-08-16 00:00:00:000
> How could I modify it as 93/08/16 (Chinese year)
> (93 is Chiense year, 2004 - 1911 = 93)
> Thanks!
> Angi
>

date format transfer

Hi,
My data type of date field is smallint,
I select it and get 2004-08-16 00:00:00:000
How could I modify it as 93/08/16 (Chinese year)
(93 is Chiense year, 2004 - 1911 = 93)
Thanks!
Angi
SELECT CONVERT(CHAR(8), DATEADD(YEAR, -11, column), 11) FROM table
http://www.aspfaq.com/
(Reverse address to reply.)
"Angi" <angi@.microsoft.com> wrote in message
news:O6NtrG6gEHA.3016@.tk2msftngp13.phx.gbl...
> Hi,
> My data type of date field is smallint,
> I select it and get 2004-08-16 00:00:00:000
> How could I modify it as 93/08/16 (Chinese year)
> (93 is Chiense year, 2004 - 1911 = 93)
> Thanks!
> Angi
>

date format transfer

Hi,
My data type of date field is smallint,
I select it and get 2004-08-16 00:00:00:000
How could I modify it as 93/08/16 (Chinese year)
(93 is Chiense year, 2004 - 1911 = 93)
Thanks!
AngiSELECT CONVERT(CHAR(8), DATEADD(YEAR, -11, column), 11) FROM table
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Angi" <angi@.microsoft.com> wrote in message
news:O6NtrG6gEHA.3016@.tk2msftngp13.phx.gbl...
> Hi,
> My data type of date field is smallint,
> I select it and get 2004-08-16 00:00:00:000
> How could I modify it as 93/08/16 (Chinese year)
> (93 is Chiense year, 2004 - 1911 = 93)
> Thanks!
> Angi
>