how to change the time of Datetime field
631274May 15 2008 — edited May 16 2008How can I update only the time portion of a datetime field in my database?
Example:
datetime field = '30-Aug-2006 12:10:00 PM' to '30-Aug-2006 12:15:00 PM'
I can select the entrys with the command
select * from terminliste where to_char(beginn,'mi') = 10;
but i dont know how to change the entrys
update terminliste set to_char(beginn,'mi') = 15 where to_char(beginn,'mi') = 10;
dosnt work.