Search
 
SCRIPT & CODE EXAMPLE
 

SQL

oracle session date format

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

PREVIOUS NEXT
Code Example
Sql :: python how to connect to sql server 
Sql :: rename table in mysql 
Sql :: DUPLICATE column values 
Sql :: sql random sampling per group 
Sql :: hw to delete a procedure in pl sql 
Sql :: group by mysql and concatenate string 
Sql :: mysqldump csv 
Sql :: oracle plan hash value 
Sql :: sql join exists 
Sql :: remove password from root mysql 
Sql :: oracle apex list connected users 
Sql :: convert uniqueidentifier to varchar in sql 
Sql :: mysql copy table1 to table2 
Sql :: how to get table structure in sql server 
Sql :: mysql order by desc limit 
Sql :: create temporary table in mysql 
Sql :: update set with inner join oracle 
Sql :: t SQl Checking Your Username 
Sql :: SQL query to convert DD/MM/YYYY to YYYY-MM-DD 
Sql :: select first rows postgresql 
Sql :: oracle list of long running queries 
Sql :: create mysql user 
Sql :: using distinct count in sqlite3 
Sql :: is there any command to change postgres password 
Sql :: mysql backup skip table 
Sql :: mysql python 
Sql :: oracle sysdate 
Sql :: how to pass password mysql command line 
Sql :: sql remove not null constraint 
Sql :: tsql row number 
ADD CONTENT
Topic
Content
Source link
Name
7+5 =