Horje
postgresql get last day of month Code Example
postgresql get last day of month 
SELECT (date_trunc('month', '2017-01-05'::date) + interval '1 month' - interval '1 day')::date
AS end_of_month;
Source: stackoverflow.com
postgresql get last day of month 
create function end_of_month(date)
returns date as
$$
select (date_trunc('month', $1) + interval '1 month' - interval '1 day')::date;
$$ language 'sql'
immutable strict;
Source: stackoverflow.com



Sql

Related
how to check last gather stats on table in oracle Code Example how to check last gather stats on table in oracle Code Example
mysql backup skip table Code Example mysql backup skip table Code Example
woocommerce mysql price table Code Example woocommerce mysql price table Code Example
python escape string for sql Code Example python escape string for sql Code Example
replace all numbers in mysql Code Example replace all numbers in mysql Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje