CODEWITHSUNDEEP
postgresql
Goku
Goku

Reputation: 1840

Postgresql How extract date

I need get only the date from now() at my time zone, I have this query:

SELECT now() AT TIME ZONE 'America/Santiago'

And I'm getting something like this "2015-06-08 23:59:34.142569" but I need extract only the date, how can I get it? Thanks.

Upvotes: 0

Views: 108

Answers (2)

Kristján
Kristján

Reputation: 18803

If you want the server's date,

SELECT current_date;

If you need the date for any timestamp, eg the one you've gotten into your timezone, use date().

SELECT date(now() AT TIME ZONE 'America/Santiago');

Docs: http://www.postgresql.org/docs/current/static/functions-datetime.html

Upvotes: 4

Kip Diskin
Kip Diskin

Reputation: 192

For postgres you want 

select current_date;

if you need to extract any of those fields out of the returned value you can use extract

EXTRACT (field FROM source)

Upvotes: 0

Related Questions