Postgresql How extract date

Question

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.

Kristján · Accepted Answer · 2015-06-09 05:36:45Z

4

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');

user330315

answered Jun 9, 2015 at 3:06

Kristján

19k5 gold badges55 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thanks for the better doc link, @a_horse_with_no_name!

Kip Diskin · Accepted Answer · 2015-06-09 03:09:18Z

0

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)

answered Jun 9, 2015 at 3:04

Kip Diskin

1921 silver badge6 bronze badges