date format transfer

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Angi (angi_at_microsoft.com)
Date: 08/16/04 

Date: Mon, 16 Aug 2004 22:56:28 +0800

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

Relevant Pages

  • RE: Length of smallint field
    ... Most Informix data types have implicit casts to character types and vice ... HOUR TO MINUTE data type, but here's a smallint version: ... Subject: Length of smallint field ...
    (comp.databases.informix)
  • Re: Localization Question - Level of Effort
    ... Modify all ASPX pages to use resource files for English and Chinese ... Modify database to hold multiple language versions of all text data. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Interface manue buttons vanished in Office 2008 for mac
    ... I have both Simplified Chinese and Traditional Chinese enabled in ... environment or Chinese Traditional environment, ... May be to modify some system files can solve the problems, ... McGhie Information Engineering Pty Ltd ...
    (microsoft.public.mac.office)
  • How to keep from importing dupe records
    ... fields have the same data type and context, although they have different field names). ... prevent "3-field combination" duplicates from being committed. ... Modify the structure of "tbl_FINAL" so that the combination of the 3 fields is UNIQUE. ...
    (microsoft.public.sqlserver.programming)
  • Re: IDENTITY Problem
    ... Identity overflow depends up on the data type definition in table. ... the data type is "smallint", then the maximum value allowed is 32,767. ... declare @cnt smallint ...
    (microsoft.public.sqlserver.programming)