Creating a timestamp Column

If you create a column named timestamp without specifying a datatype, SAP ASE defines the column as a timestamp datatype.

create table testing 
    (c1 int, timestamp, c2 int)

You can also explicitly assign the timestamp datatype to a column named timestamp:

create table testing 
    (c1 int, timestamp timestamp, c2 int)

You can also explicitly assign the timestamp datatype to a column with another name:

create table testing 
    (c1 int, t_stamp timestamp,c2 int)

You can create a column named timestamp and assign it another datatype (although this may be confusing to other users and does not allow the use of the browse functions in Open Client™ or with the tsequal function):

create table testing 
    (c1 int, timestamp datetime)