Search
 
SCRIPT & CODE EXAMPLE
 

SQL

get date ISO in psql

SELECT cast(to_char (now()::timestamp at time zone 'UTC', 'YYYY-MM-DD"T"HH24:MI:SS"Z"') as varchar)
Comment

PREVIOUS NEXT
Code Example
Sql :: sql concat string with column value 
Sql :: restore postgres database from dump 
Sql :: mysql show attributes of a table 
Sql :: db.Database.SqlQuery 
Sql :: install beautifulsoup from terminal 
Sql :: date diff sql 
Sql :: sql server query all database objects 
Sql :: get comma separated values in sql server 
Sql :: postgresql to_char time 
Sql :: mysql CAST(amount as float) 
Sql :: update column data type postgres 
Sql :: mysql limit rows 
Sql :: amazon linux postgresql client 
Sql :: pl/sql loop example 
Sql :: mysql select multiple rows into one column 
Sql :: backup a table in sql 
Sql :: identify number of rows in sql 
Sql :: min salary in sql 
Sql :: how to use rank function in sql 
Sql :: postgres concat 
Sql :: insert current date sql 
Sql :: how to export only procedures mysql 
Sql :: inner join update 
Sql :: mysql datetime to date 
Sql :: mysql email validation 
Sql :: space not removing from column in sql 
Sql :: oracle running queries sql 
Sql :: mysql get latest duplicate rows 
Sql :: rename a table in sql server 
Sql :: IS NOT NULL statement 
ADD CONTENT
Topic
Content
Source link
Name
1+6 =