Sql

SELECT
   DATEADD(yy, DATEDIFF(yy, 0, GETDATE()), 0) AS StartOfYear,
   DATEADD(yy, DATEDIFF(yy, 0, GETDATE()) + 1, -1) AS EndOfYear

PREVIOUS	NEXT

Code Example
Sql :: oracle turn off constraint
Sql :: oracle sql log to console
Sql :: mysql concatenate two columns into one
Sql :: oracle table statistics
Sql :: oracle user last connection date
Sql :: Job for mysql.service failed because the control process exited with error code. See "systemctl status mysql.service" and "journalctl -xe" for details.
Sql :: oracle stop job
Sql :: select password from user mysql
Sql :: status mysql
Sql :: mysql dump database command line linux
Sql :: search for tables with name postgresql
Sql :: netstat -tln mysql
Sql :: bulk kill mysql processlist
Sql :: list all permissions on a table in postgres
Sql :: mysql count newlines in field
Sql :: install mysql powershell
Sql :: Starting mysql shell lampp ubuntu
Sql :: oracle list invalid password ORA-01017
Sql :: how to check database size in mysql
Sql :: sql get tables from current database you working with
Sql :: snowflake alter column data type
Sql :: oracle list tablespaces
Sql :: postgresql select as and fwhwere by this field
Sql :: oracle nls instance
Sql :: postgres show current role
Sql :: ddl materialized view
Sql :: change month to name in sql server
Sql :: default password of mysql
Sql :: create temporary table in mysql
Sql :: set auto increment to 1 mysql