Updating date in sql

Which database are you using e.g with My SQL you'd have to do HI, DO THE FOLLOWING: 1.USE THIS QUERY : SELECT DUEDATE, OLDDATE FROM FACTORYORDER; 2. Just make sure that the date format (second argument) is understood by Oracle... to_date('20090511','yyyymmdd') to_date('2009 11 05 ','yyyy dd mm') or even to_date('','yyyy') will all work... J" id="ctl00_m_m_i_ctl00_gr_ctl01_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="2775841" / CREATE TABLE SVEULUME.

Let us check this by an example: Firstly we take a table in which we want to update date and time fields.

If WHERE condition is entirely removed it will provide details of the entire database.

Reference : Pinal Dave (https://blog.sqlauthority.com)Hi Pinal, Since my server was started one month back, I am getting last_user update (2015-07-31) for a table.

Hi there, just moving your post to one of the SQL forums, where the experts will be far better qualified to address your query.

A link to this thread will be left in the introductions this time, however in future you can use the blue bar above to navigate through the forums Hi and Welcome to TSDN. You should have specified the error that you're getting and posted this in a relevant database forum.