Page History

...

• Full timestamp (YYYY-MM-DD HH:MM:SS[.f....]
  Seconds must always be specified, and the fractional part may only be specified where the native datatype supports it, and only for the maximum length the column was set to when added to the Data Dictionary.
  
  After a fetch from the table, the column will always be in this format, unless it is NULL, in which case it will be blanks. If the row is then updated, LANSA will automatically set the column to *TIMESTAMP_DFT as blank is not valid.
• Date only (YYYY-MM-DD)
  If the column is inserted/updated, the time portion will be automatically set to 00:00:00
• Time only (HH:MM:SS.[f...])
  If the column is inserted, the date portion will be automatically set to '1900-01-01'. The same format rules apply as for the full timestamp. Do not specify a fractional part if it cannot be specified in the full timestamp format. 
• If the column is used in an I/O command and is not in a valid format, a fatal error will occur. On insert or update some datatypes may be successfully converted  by the DBMS from other formats, although this is not recommended. If data may be manually entered, you should use virtual columns to convert to and from the above formats.

See Also

...

Using SQL Server datatype Smalldatetime

...