|
View previous topic :: View next topic
|
| Author |
Message |
rsm_deepak
New User
Joined: 06 Apr 2005
Posts: 30
Location: visakhapatnam
|
|
|
|
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? |
|
| Back to top |
|
 |
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| '0001-01-01-12.00.00.000001' |
|
| Back to top |
|
|
rsm_deepak
New User
Joined: 06 Apr 2005
Posts: 30
Location: visakhapatnam
|
|
|
|
Thanks for quick response.
But can't we give 0001-01-01-00.00.00.000000? |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
| rsm_deepak wrote: |
Thanks for quick response.
But can't we give 0001-01-01-00.00.00.000000? |
yes........... |
|
| Back to top |
|
|
Suresh Ponnusamy
Active User
Joined: 22 Feb 2008
Posts: 107
Location: New York
|
|
|
|
Hi rsm,
I think you can give 0001-01-01-00.00.00.000000. Please check. I used this in my program. |
|
| Back to top |
|
|
mkarthikeyan
New User
Joined: 07 Aug 2008
Posts: 34
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 |
|
| Back to top |
|
|
|
|
