If you create a column named timestamp without specifying a datatype, Adaptive Server 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)
or 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 could be confusing to other users and would not allow the use of the browse functions in Open Client™ or with the tsequal function):
create table testing (c1 int, timestamp datetime)
