Default values for Timestamp

rsm_deepak · Posted: Thu Aug 07, 2008 1:59 pm Post subject: Default values for Timestamp

I have a added a new column name with the type Timestamp(neither create nor updated - it is just a time its opertated based on when the decision took) in my table.

If I get the value i will insert it.

The question started what if I won't get a value of the timestamp
Here I guess I need to move the default value.

Since it is the the timestamp what I need to move?
Can I move Zeroes or Spaces?

dbzTHEdinosauer · '0001-01-01-12.00.00.000001'

'0001-01-01-12.00.00.000001'

rsm_deepak · Posted: Thu Aug 07, 2008 2:36 pm Post subject:

Thanks for quick response.
But can't we give 0001-01-01-00.00.00.000000?

dbzTHEdinosauer · Posted: Thu Aug 07, 2008 2:53 pm Post subject:

Suresh Ponnusamy · Posted: Thu Aug 07, 2008 7:19 pm Post subject:

Hi rsm,

I think you can give 0001-01-01-00.00.00.000000. Please check. I used this in my program.

mkarthikeyan · New User Joined: 07 Aug 2008 Posts: 26 Location: Bangalore

Declare the timestamp column as Nullable. If the timestamp value is missing in the input then move -1 to the null indicator variable else move zero to the null indicator and input timestamp to the host variable. Insert the row into the table. the suggestion is given based that you are going to design the column & column type.

Thanks
Karthikeyan

[S/360] was the biggest, riskiest decision I ever made, and I agonized about it for weeks,but deep down I believed there was nothing IBM couldn't do.
- Tom Watson, Jr. IBM Chairman and CEO 1961-1971