In my database, I have a list of users with the user ids and their UTC offset in minutes. It’s in a PostgreSQL database which I access through sequelize in my node application. For example: I want to create a query that, when run, gets me a list of users that have passed 12pm noon their local time. For …
Tag: timezone
PostgreSQL get results in current time zone
as said in the title I would like to have a query that returns the value of the time stamp in my current time zone (even according summer time!). my_table is: (Don’t ask me why I cannot put this table directly in markdown…prob cause the dates) Now for example if I have to select the 24h correspond…
Error while converting timestamp string with timezone (+0000) to Timestamp in Presto
I am trying to convert a timestamp string to timestamp with date_parse, but keep getting an error. Any suggestions? I am working on Presto SQL. I also refered: http://teradata.github.io/presto/docs/127t/functions/datetime.html, but couldnt find anything that can deal with +0000 i.e Timezone. I tried: throws m…
How to get all data post midnight of different timezone?
I have a PostgreSQL table named testing with a column named creation_time as timestamp with time zone. The database timezone is UTC Now I want to get all rows whose time is greater than 00:00 of the current day as per the timezone “America/New_York”. I know how to get all rows after local midnight…
Handling of generate_series() in queries with date or timestamp with / without time zone
I have a query to generate a report based on a date series that is grouped by date and employee_id. The date should be based on a particular time zone, in this case ‘Asia/Kuala_Lumpur’. But this can change depending on where the user’s time zone is. Definition and sample data for table atten…
Proper way of getting rows since a date accounting for DST?
I have a datetime column, changedate, that I need to use to get rows that have changed in the last week since 1PM. This column is unfortunately in local time (EST). The server is Microsoft SQL Server 2016. Here is the query I have now: Since I’m using AT TIME ZONE for both the column and @since, will th…
CONVERT_TZ() equivalent in Oracle
I am trying to convert a timestamp value of the format YYYY-MM-DDTHH24:MI:SS to another timezone value YYYY-MM-DD HH24:MI:SS.SSSSSS. I was able to do this in MySql using the CONVERT_TZ(date, from_tz, …
Store in UTC in SQLite and display in local timezone with PHP
I have a table containing a datetime column: and I add a row (storing the datetime of the addition of the row in UTC) with This works. Now when displaying the rows: the date is displayed like this, in UTC: 2019-04-27 16:41:33. How to display it in the local timezone instead? (including Daylight Saving) I can …
Postgres time with time zone equality
I’m having some trouble with time with time zone equalities in Postgres. timestamp with time zone equality works how I would expect it to, where if the times are the same after normalizing the …
Can MySQL convert a stored UTC time to local timezone?
Can MySQL convert a stored UTC time to local time-zoned time directly in a normal select statement? Let’s say you have some data with a timestamp (UTC). CREATE TABLE `SomeDateTable` ( `id` int(11)…