SQL Syntax

[Ruslan Zasukhin]

On 31/1/07 8:05 PM, "Bernet, Eytan" <eytan_bernet at mcgraw-hill.com> wrote:

Hi,

> 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?

Do you mean that record is created by default value is not inserted?

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]