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 :: SQL Duplicates by Composite
Sql :: subquery in sql
Sql :: what is a query in sql
Sql :: sql server query database space available
Sql :: postgresql check total storage
Sql :: Cannot invoke "java.sql.Connection.prepareStatement(String)" because "con" is null
Sql :: alter or change postgresql sequence counter
Sql :: rename column mysql
Sql :: get initials name in sql
Sql :: to_char sql
Sql :: mysql count rows returned
Sql :: mysql biginteger size
Sql :: insert into auto increment mysql
Sql :: how to run sql server on mac
Sql :: postgres extract time from timestamp
Sql :: postgresql in array
Sql :: sql server check whether column has same equal values
Sql :: postgres sum when
Sql :: mysql find_in_set join
Sql :: distinct in sql server
Sql :: order by multiple columns
Sql :: sql count more than 1
Sql :: postgresql backup and restore globals and data
Sql :: sql inner join
Sql :: sql remove check constraint
Sql :: sql order by number not ordered
Sql :: oracle drop default value
Sql :: SELECT DISTINCT on one column, with multiple columns returned, ms access query
Sql :: sql select most frequent value in group
Sql :: Oracle filter date column by year