Default INITVALUE For date / date time

kamranshehzad

Hi

When I set default INITVALUE of t/ T in date field on table 122 it inserts 13/10/09 instead of 16/10/09.
Strange.. or perhaps I am doing something wrong.
system date is 16/10/09

Any idea?

DenSter

October 13, 2009 is a Tuesday, which starts with a T

kamranshehzad

So how do i get system date for using initvalue for datetime datatype for a column in a table?