View previous topic :: View next topic
|
Author |
Message |
anand_smail
New User
Joined: 05 Jun 2005 Posts: 13
|
|
|
|
Hi,
Can anybody tell me what is the syntax for updating the date column with Current Date in DB2? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Which date column? How is this column defined in your system?
You have most likely received no replies because of the way the question was posted. |
|
Back to top |
|
|
callkris_cit
New User
Joined: 22 Apr 2006 Posts: 44
|
|
|
|
Sample Date Update:
If your DB2 field column have the type as DATE then,
UPDATE WH_DATE = CURRENT_DATE
FROM TABLE1 |
|
Back to top |
|
|
callkris_cit
New User
Joined: 22 Apr 2006 Posts: 44
|
|
|
|
Sorry. Ignore my previous reply
UPDATE TABLE1
SET WH_DATE = CURRENT_DATE |
|
Back to top |
|
|
|