How to return current date in a different timezone in PostgreSQL
I'm working on an application which uses Eastern time with a database set to Pacific time. This has been causing some issues, but we're told that it can't be any other way, so we just have to work around it.
Anyway, one of the things I'm having trouble with is getting today's date. Since the database is in Pacific, if I ask for today's date using current_date at, say, 1AM, it'll give me yesterday's date. I've tried setting timezone and adding/subtracting intervals, but it never seems to work the way I expect it to, and I'd rather not have to do extensive testing at 1AM to get this to work.
Is there a somewhat simple way to return a DATE for today's date in a given time zone in PostgreSQL?
select current_date at time zone 'UTC',current_date::timestamp ;
or any other zone
update:
select (current_date at time zone 'UTC')::date,current_date::date
- ruby raised another command is already in progress
- Find modal values in each row, with custom tie breaking in PostreSQL
- Find procedure name in all other procedures
- How to use posix regexp operator for substring match
- How to get results from a Postgresql function using EF Core?
- Sql Alchemy Insert Statement failing to insert, but no error
- SELECT rows with the max count per column value after GROUP BY
- Pick random values from different table-columns (postgresql)
- django.db.utils.ProgrammingError: relation "bot_trade" does not exist
- Supabase python client returns an empty list when making a query
- How to calculate DATE Difference in PostgreSQL?
- Repeat rows specified number of times in PostgreSQL
- How to visualize database tables in postgresql using pgAdmin?
- panic: sql: expected 1 destination arguments in Scan, not <number> golang, pq, sql
- Why is Postgres not using my index on a simple ORDER BY LIMIT 1?
- Npgsql: How to setup enum mapping in Npgsql v8?
- How to reference another docker service from Dockerfile
- How to differentiate a Cypher clause from an SQL clause in C?
- using sql joins vs using separated methods in java
- Prisma Supabase: Invalid format for user or db_name after initial migration
- Laravel Model casts not working properly
- Export specific rows from a PostgreSQL table as INSERT SQL script
- Retaining and inserting state into a postgres aggregation function
- Spring JPA with docker compose: Unable to determine Dialect without JDBC metadata (please set 'jakarta.persistence.jdbc.url' or 'hibernate.dialect'
- PostgreSQL - ERROR: column does not exist SQL state: 42703
- Function to return dynamic set of columns for given table
- How to force evaluation of subquery before joining / pushing down to foreign server
- How to install postgresql-client to Amazon EC2 Linux machine?
- Unterminated dollar-quoted string reported by goose when creating PostgreSQL function
- How to compute the sum of multiple columns in PostgreSQL