var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Update time into the "date" type field.
I want to update time in the field which has data type DATE in oracle
so how would i write a statement.
I m updating the following command which is not working.
update ord set recept_hh=to_char(200900,'hh24:mmS') where sampleid='0040022A';
------------- above example recept_hh -> is a date data type
would u please helpe me
Thank you a lot....
Presumably recept_hh already has a date in it that you don't want to change, so you need to include that in the new value:
set recept_hh = to_date ( to_char(recept_hh,'YYYYMMDD')||'200900'