Table of ContentsPreviousNext

Ispirer
Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.
You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.
Check out the relevant toolkit documentation.
Ispirer Sybase ASE Migration overview.


Ispirer SQLWays Database Migration Software

date, datetime, smalldatetime, time and timestamp

Date and time data types for representing date and time of day.

date

date data type is used to store year, month and day.

The range is from January 1, 0001, through December 31, 9999. Storage size is 4 bytes.

A date column can also contain an hour and minute if the TRUNCATE_DATE_VALUES option is set to OFF.

datetime
smalldatetime

These data types are the aliases for built-in data type timestamp. These data types are used to store year, month, day, hour, minute, second and fraction of second. The fraction is stored to 6 decimal places.

The range is from January 1, 0001 00:00:00.000000, through December 31, 9999 23:59:59.999999. Storage size is 8 bytes.

These data types are provided primarily for compatibility with Adaptive Server Enterprise.

time

This data type is used to store hour, minute, second and fraction of a second. The fraction is stored to 6 decimal places. Storage size is 8 bytes.

timestamp

This data type is used to store year, month, day, hour, minute, second and fraction of second. The fraction is stored to 6 decimal places.

The range of possible dates is the same as for the date type, but the usefull range lies between 1600-02-28 23:59:59 and 7911-01-01 00:00:00. If the value is not in this range, the time portion may be incomplete. It requires 8 bytes of storage.


Table of ContentsPreviousNext
Copyright 1999-2023 Ispirer Systems.
Ispirer and SQLWays are registered trademarks. All other product names may be trademarks of the respective companies.
All rights reserved.