Sql

  --string to date
  SELECT cast(convert(date, '23/07/2009', 103) AS DATE)
  select convert(date, '23/07/2009', 103)

select CONVERT(char(10), GetDate(),103)
/* 30/06/2021 */

PREVIOUS	NEXT

Code Example
Sql :: postgresql if 0 then 1
Sql :: how to get all table names in sql query
Sql :: file /etc/init.d/mysql not exists
Sql :: sqlite insert row
Sql :: oracle sleep 1 second
Sql :: import sql file laravel cmd
Sql :: sql eliminare un record
Sql :: how to give user privelege to create dblink in oracle
Sql :: mysql greater thatn a week ago
Sql :: mysql remove last empty newline
Sql :: ORACLE RIGHT TWO DIGITS
Sql :: upload database mysql command line
Sql :: sql change table name
Sql :: Postgres upgrade to superuser
Sql :: sql reset auto increment
Sql :: ordering by issue with 4 digit numbers in sql
Sql :: postgresql get current user name
Sql :: how to start mysql in terminal
Sql :: mysql reset auto increment
Sql :: oracle session date format
Sql :: mysql show charset
Sql :: import sql file in mysql
Sql :: oracle list dates between
Sql :: inner join just one row
Sql :: access the postgres psql
Sql :: oracle stop
Sql :: row number mysql
Sql :: SQL query to convert DD/MM/YYYY to YYYY-MM-DD
Sql :: sql server delete top 1000
Sql :: backup ms sql database table data to file