Does 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