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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to correct time component in date field

Status
Not open for further replies.
blom0344

blom0344

Technical User
Mar 20, 2002
3,441
NL
How can I update the time component in a date-field?
Suppose I want to change '24-02-06 9:47:03' to '24-02-06 5:00:00' with an SQL statement?

Thanks

Ties Blom

 
Sort by date Sort by votes

Try:
Code: 
Update MyTable
   Set Date_Field= TRUNC(Date_Field)+5/24;
[3eyes]

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

J
  • Question
Oracle Simphony - Adding tip out percentages to Employee Tip Report 1
Replies
0
Views
77
jj10438
J
sqlPower
  • Locked
  • Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
786
SkipVought
S
Livia8
  • Locked
  • Question
How to forcibly logout users 2
Replies
17
Views
1K
carp
carp
Andrzejek
  • Locked
  • Question
Show value from DATA_DEFAULT field 1
Replies
2
Views
901
Andrzejek
Andrzejek
Chopstik
  • Locked
  • Question
How to identify a package based on a code snippet 1
Replies
1
Views
722
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top