Editorial question107K views4,945 votes0 answers3,315 following
AI-generatedDoes Phoenix CURRENT_DATE return consistent results across different connection timezone sessions?
Phoenix TIMESTAMP and Date Function Timezone Behavior Phoenix stores TIMESTAMP values internally in UTC, but date-related functions like CURRENT_DATE depend on the connection session's timezone setting. This creates potential inconsistency when multiple clients in different regions query the same table. The Phoenix Query Server and thin JDBC driver may apply