SQL Syntax

[Bernet, Eytan]

I am creating a table with two date fields, a creation timestamp and an
updated timestamp. I am doing it in this manner:

CreateDate TIMESTAMP DEFAULT CURRENT_TIMESTAMP   (for the creation) and
ModDate TIMESTAMP DEFAULT TIMESTAMP

After creating these fields in this table I connect to the database using
VStudio and create a record - I am not seeing these fields filled. Am I
doing something wrong?

Thank You
Eytan Bernet