Sql

Search

sql first day of current year

SELECT DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), 0);			-- SQL Server
SELECT TRUNC(sysdate, 'YEAR') FROM DUAL;					-- Oracle
SELECT MAKEDATE(year(now()), 1);							-- MySQL

Comment

PREVIOUS	NEXT

Code Example
Sql :: c# datetime to sql server datetime
Sql :: mysql update part of string
Sql :: mysql add column if not exists
Sql :: sql_mode=only_full_group_by
Sql :: OSError: mysql_config not found
Sql :: fetch first 10 rows in oracle sql developer
Sql :: how to start mysql
Sql :: sql several or
Sql :: how to set an already made tables auto increment in mysql
Sql :: how to unlock table in mysql
Sql :: postgresql print sessions using the database
Sql :: mysql remove last character
Sql :: add sequence postgres
Sql :: create schema sql server
Sql :: how to remove unique key constraint in mysql
Sql :: wordpress change http to https phpmyadmin
Sql :: mysql text type max length
Sql :: mysql not supported auth mode
Sql :: grant permission in postgres
Sql :: create table if not exists sql
Sql :: mysql format date
Sql :: ms sql how to see active job current run time
Sql :: mysql delete binlog
Sql :: create a table with an id in mysql
Sql :: add new column to the table mysql
Sql :: oracle show trigger code
Sql :: hibernate with springboot mysql
Sql :: postgresql show owner of database
Sql :: oracle view source
Sql :: change month to name in sql server

Search

SQL

sql first day of current year

ADD CONTENT