Sybase IQ has date, time, and timestamp types that include year, month, day, hour, minutes, seconds, and fraction of a second. For insertions or updates to date fields, or comparisons with date fields, a free-format date is supported.
In addition, the following operations are allowed on dates:
Date Operation |
Description |
|---|---|
date + integer |
Add the specified number of days to a date. |
date - integer |
Subtract the specified number of days from a date. |
date - date |
Compute the number of days between two dates. |
date + time |
Make a timestamp out of a date and time. |
Also, many functions are provided for manipulating dates and times.