Constants

Restriction: This topic applies to Windows environments only.

Constants are specific values. Constants may be classified as character string, date, time, timestamp or numeric constants. Character string constants appear inside quotes (single or double) in SQL commands. Numeric constants are subdivided into integer (including both integer and smallint), float, and money constants, according to the data type into which they fall. In SQL commands, date constants should be in the form mm/dd/yy or mm/dd/yyyy (the slash ( / ) is not interpreted as a division operator if the value is determined to be a date). If another date format is used, the date string must be enclosed in quotes. In SQL commands, time constants should be of the format hh:mm:ss. If another time format is used, the date string must be enclosed in quotes. Timestamp constants should be in the format yyyy-mm-dd-hh.mm.ss.nnnnnn.