Skip to content

Instantly share code, notes, and snippets.

@gerep
Created Aug 22, 2017
Embed
What would you like to do?
PostgreSQL: yesterday, today, tomorrow
select TIMESTAMP 'yesterday';
select DATE 'yesterday';
select TIMESTAMP 'today';
select DATE 'today';
select TIMESTAMP 'tomorrow';
select DATE 'tomorrow';
select TIME 'allballs';
select now();
select TIMESTAMP 'now';
select DATE 'now';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment