Answers for "update string to date time in sql server"

sql server convert string to date

select Cast( '2021-09-22' as date ) as castedDate;
select convert(date,'20210922') as convertedDate;

Posted by: Guest on April-06-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 "update string to date time in sql server"