SQL$HELP_OLD72.HLB  —  Built In Functions, CURRENT_TIMESTAMP
    The CURRENT_TIMESTAMP function returns a TIMESTAMP data type
    value containing year, month, and, day for date 'today' and
    hours, minutes, and seconds for time 'now'.

    As in CURRENT_TIME, you can specify a fractional precision
    between 0 and 2 for the seconds returned by CURRENT_TIMESTAMP.
    The fractional-seconds precision is a number that designates the
    number of digits returned in the field.

    The CURRENT_TIMESTAMP data type can be either DATE VMS or DATE
    ANSI format. Date-time arithmetic is not allowed with DATE VMS
    columns. A DATE VMS format CURRENT_TIMESTAMP specifies the day,
    month, and year of the current date and the hours, minutes, and
    seconds of the current time. A DATE ANSI format CURRENT_TIMESTAMP
    specifies the year, month and day of the current date, followed
    by the hours, minutes, and seconds of the current time.
Close Help