Sql

Search

sql first day quarter

-- trunc(date, format)						DUAL is for Oracle
SELECT trunc(sysdate, 'Q') FROM DUAL;       -- 1rst quarter day
SELECT trunc(sysdate) FROM DUAL;            -- today 00:00:00
SELECT trunc(sysdate, 'YEAR') FROM DUAL;    -- 1rst year day
SELECT trunc(sysdate, 'MONTH') FROM DUAL;   -- 1rst month day

Comment

PREVIOUS	NEXT

Code Example
Sql :: change order of sql columns
Sql :: utf8_encode mysql
Sql :: delete duplicate data from table
Sql :: run sql command line download
Sql :: create view in mysql workbench
Sql :: add 10 to all numbers in a column sql
Sql :: pl sql round
Sql :: timing sql queries
Sql :: stored procedure to change name of column for all dependent tables and views
Sql :: https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
Csharp :: asp.net data annotations email
Csharp :: unity load current scene
Csharp :: c# random number between 1 and 100
Csharp :: Point to mouse 2D Unity
Csharp :: c# combobox prevent typing
Csharp :: how to delete all files in a directory c#
Csharp :: c# open folder in explorer
Csharp :: c# if file exists
Csharp :: c# check if textbox is not empty
Csharp :: unity coroutine
Csharp :: c# play sound
Csharp :: c# initialize dictionary
Csharp :: format phone number in c# .net
Csharp :: how to make a method wait in unity
Csharp :: how to delete folder with files on c#
Csharp :: get path c#
Csharp :: c# private set
Csharp :: load scene unity
Csharp :: how to move your character in unity 2d game
Csharp :: c# round to 2 decimal places

Search

SQL

sql first day quarter

ADD CONTENT