Answers for "sql query to change date"

how to update date value in sql

UPDATE TABLE
   SET EndDate = CAST('2009-05-25' AS DATETIME)
 WHERE Id = 1

Posted by: Guest on March-09-2020

sql change date format

-- Oracle
ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MM-YYYY HH24:MI:SS';
SELECT sysdate FROM dual;

SELECT to_char(sysdate,'HH24:MI:SS') FROM dual;

Posted by: Guest on August-15-2021

Code answers related to "sql query to change date"