Answers for "change date format sql"

SQL
2

SQL Date Format

SELECT FORMAT(dbo.column, 'M/dd/yyyy')
Posted by: Guest on December-09-2020
0

sql convert date to string yyyy-mm-dd

select CONVERT(char(10), GetDate(),126)
/* 2020-12-23 */
Posted by: Guest on December-23-2020
0

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"

Browse Popular Code Answers by Language