DEFAULT comand for DATE instead of DATETIME ?

[Sudmill]

Hi,

I am perfoming a conversion of SQL Server database to DB2. The IBM porting document Im using suggests that I should use the TIMESTAMP datatype (for a SQLServer DATETIME datatype).

The problem is the front end Access application doesnot specify dates in the required format e.g.;

2003-09-14-00.00.00.000000

This means that I will need to use the DATE datatype, which will hopefully work with the front end without any changes.

The DEFAULT option for TIMESTAMP is (DEFAULT CURRENT TIMESTAMP) when creating tables. What should I use to automatically insert the DATE into a DATE field?

Sorry if this is dumb question...



Cheers

John (Sudmill)

 

[gregsimpson]

John,

not sure I've followed but is it simply

CURRENT DATE

your after?

Cheers
Greg

 

[Sudmill]

I found this out yesterday but couldnt get onto Tek-tips site to update my mewbie question.Doh!

Simply by specifying the DEFAULT statement, DB2 will imply a relevant default option without you having to type it out explicitly.

The following is useful information for anyone else who may need it. Obtained from the following URL.

http://www-3.ibm.com/cgi-bin/db2www...support/v8document.d2w/report?fn=r0000888.htm

Table 78. Default Values (when no value specified)

Numeric
0
Fixed-length character string
Blanks
Varying-length character string
A string of length 0
Fixed-length graphic string
Double-byte blanks
Varying-length graphic string
A string of length 0
Date
For existing rows, a date corresponding to January 1, 0001. For added rows, the current date.
Time
For existing rows, a time corresponding to 0 hours, 0 minutes, and 0 seconds. For added rows, the current time.
Timestamp
For existing rows, a date corresponding to January 1, 0001, and a time corresponding to 0 hours, 0 minutes, 0 seconds and 0 microseconds. For added rows, the current timestamp.
Binary string (blob)
A string of length 0

Omission of DEFAULT from a column-definition results in the use of the null value as the default for the column.




Cheers

John (Sudmill)

 

[Sudmill]

Thanks for replying btw !