Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date to Timestamp

Status
Not open for further replies.
SDyke

SDyke

MIS
Oct 13, 2005
55
US
I have a field with a date 01/01/2009 datatype L I have a field with data type Z. I would like a update sql string that would fill in the timestamp field based on the value of the data field. The time can be 00:00:00.
 
Sort by date Sort by votes
Code: 
update MyTable set MyTimeStamp = cast(MyDateFld as TimeStamp)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tekpr00
  • Locked
  • Question
Adding storage to DB2 PureScale Cluster
Replies
0
Views
215
tekpr00
tekpr00
cloudtwter
  • Locked
  • Question
CASE DATE
Replies
5
Views
112
cloudtwter
cloudtwter
ANGELDANY
  • Locked
  • Question
WEEK ISO with Dates in string format YYYYMMDD 1
Replies
4
Views
273
ANGELDANY
ANGELDANY
Khaleel2408
  • Locked
  • Question
Unable to connect to DB2 database server over sec port using SSL from windows ODBC DSN client
Replies
0
Views
154
Khaleel2408
Khaleel2408
Kuldeepg
  • Locked
  • Question
Timestamp_format is not libl function
Replies
1
Views
150
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top