Sql

-- 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;

PREVIOUS	NEXT

Code Example
Sql :: mysql version
Sql :: create user mariadb
Sql :: SQL ORDER BY ASC (Ascending Order)
Sql :: sql server insert into table
Sql :: sqlalchemy update row
Sql :: create database in mysql
Sql :: snowflake drop column
Sql :: difference between join vs union
Sql :: postgres duplicate key value violates unique constraint already exists
Sql :: sql distinct only one column
Sql :: sql between operator
Sql :: postgresql get date from datetime
Sql :: psql execute sql file
Sql :: enter mysql command line
Sql :: como consultar registros duplicados en mysql
Sql :: regenerate assets odoo
Sql :: change password postgres pgserver
Sql :: enable full text search mysql
Sql :: how to remove unique key in mysql
Sql :: c# update sql statement
Sql :: insert into values select
Sql :: create table query in mysql
Sql :: between keyword in sql
Sql :: how to delete all duplicate items in mysql
Sql :: how to find unique key in sql
Sql :: show table mysql
Sql :: mysql add columns
Sql :: oracle select invalid views
Sql :: postgresql change user role grant
Sql :: power query add row