Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 problen in updating date field

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-06-06 : 08:11:35
sanjay writes "table sanjay having exit_date filed of type date. I want to update exite_date with timestamp

Suppose this is the sql text
select to_char(exit_date,'DD-MON-YY HH:MI:SS') from sanjay_temp;
Out put is 10-MAR-05 02:02:50

I want to change 10-MAR-05 16:26:01

.. Pls send syntaxt for this"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2005-06-06 : 08:12:45
It would be best to post this on an Oracle forum, SQL Team is a SQL Server forum. Try here:

http://dbforums.com/
Go to Top of Page
   

- Advertisement -