Sql

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;

 e.g., 01-JAN-17

PREVIOUS	NEXT

Code Example
Sql :: sql select data type of query
Sql :: sql select on string
Sql :: sql server delete records with specific date
Sql :: having clause
Sql :: what is unique key in sql
Sql :: how to find sql server installation folder
Sql :: insert multiple rows from another table sql
Sql :: operator in sql
Sql :: faire la différence entre deux tables sql big query
Sql :: mysqldump devilbox
Sql :: How To Rename Table Using MySQL RENAME TABLE Statement
Sql :: openquery join two tables
Sql :: mysql grouping functions
Sql :: calculer pourcentage mysql
Sql :: sql server obtener nombre sin espacios en blanco
Sql :: sqlite3 visual table schema
Sql :: tsql from yyyymm to date
Sql :: alter check constraint in mysql
Sql :: mssql unique key accept nulls
Sql :: how to avoid duplicate records in sqlite
Sql :: mysql having
Sql :: oracle sql trigger select into
Sql :: convert Date to LocalDate via SQLDate
Sql :: psql: error: FATAL: database "odoo" does not exist
Sql :: show broken table mysql
Sql :: Kill session in SQL Developer
Sql :: mysql multiply
Sql :: sql server express
Sql :: column must appear in the GROUP BY clause or be used in an aggregate function
Sql :: sql online compiler