2,389 questions
- Bountied 0
- Unanswered
- Frequent
- Score
- Trending
- Week
- Month
- Unanswered (my tags)
0
votes
0
answers
30
views
Multi-timezone aggregation convention
Currently the structure is like a single parent node and multi children nodes
root: HQ (timezone: 'Asia/Seoul')
children: Middle East Region (timezone: 'Asia/Riyadh'), North America Region (timezone: '...
-1
votes
2
answers
70
views
Testing for a particular date works locally, but not on GitHub
The task is to check if a certain date is a statutory holiday, by comparing a date against a list of known statutory holiday dates.
Here is the JSON list of stat holidays:
{
"provinces": ...
0
votes
1
answer
110
views
Are DBT snaopshots using check strategy capture valid from/to as UTC?
I'm using dbt cloud to generate snapshots to track SCD on a table, uing the check strategy (as I don't have an updated_at column in my source table) - this works well, and every change captures a new ...
0
votes
2
answers
117
views
Difference in precision of UTC and Local TIMESTAMP dates inserted with same statement
I have created an ALL SERVER FOR LOGON trigger in my MS SQL Server 2019 Dev Edition to keep track of login activity.
The activity is stored in a database table SYS_UNF_TRAIL that includes the ...
2
votes
1
answer
79
views
How to Format Text from General to UTC time
If I have an Excel cell with 'General' format containing 2502241433 how do I get Excel to recognise it as YYMMDDHHMM in UTC. So in this example 2502241433 means that the time is 14:33 UTC on the 24th ...
0
votes
0
answers
47
views
Override locale adapted date in Material Datepicker and Material Input
I'm using the Material Library for an Angular 18.2.10 application that uses in several parts of it the Datepicker component along with Input component, just as show in the documentation. In order to ...
-4
votes
2
answers
419
views
Add timezone to java.time.OffsetDateTime
I have this Joda-Time date which I want to migrate to java.time.OffsetDateTime:
import org.joda.time.DateTime;
private DateTime createdDate;
private String creationTime;
.....
DateTimeFormatter dtf = ...
-2
votes
1
answer
115
views
Coordinated Universal Time (UTC) option vs. Specific Time Zone in Cloud Services [closed]
Before you downvote, this question is not about time zone conversion - it is about best practices relating to time zone notation/use.
The question: in an environment or service where there is an ...
0
votes
0
answers
114
views
Google Sheet to Wix date format issues
1I have a WIX site where part of a dataset is populated via an API in Google Sheets. The data runs through Zapier and then into the Wix dataset. I have no trouble with any number or text fields; ...
-1
votes
1
answer
34
views
local time of calendar event
When I use a script like
var now = new Date(),
then = new Date();
// _interval is passed to cal.getEvents as nr of seconds
then.setSeconds(now.getSeconds() + _interval);
Logger.log('...
1
vote
0
answers
37
views
DST timing is getting wrong for Egypt
The DST timing is wrong in countries where DST starts at 12 a.m., such as (Lebanon ,Cuba, Egypt). The library we're utilizing for UTC dates
Package version:
date-fns: 2.30.0,
date-fns-tz: 1.3.8.
...
-1
votes
1
answer
378
views
Pandas Datetime conversion CET/CEST to UTC
I have a df datetime column that I want to convert from Europe/Copenhgaen t.z to UTC but I just keep getting duplicate entries in the UTC column. The reason this happens is because of how I make my ...
0
votes
1
answer
155
views
Saving datetime offset in database
I currently have a problem with saving the UTC time. I have an application in which you can specify a timer for a job and this is then saved in the database. However, I have the following problem:
The ...
1
vote
2
answers
438
views
Android Kotlin LocalDate Timestamp conversion
I have a problem with my DatePicker and the conversion of LocalDate an timestamp
When opening the DatePicker, I choose a day and on confirm I convert the timestampt to a LocalDate and store in an a ...
1
vote
0
answers
95
views
How to handle DayOfWeek field in a database when users from different time zones query the data?
I have a table in my database where one of the columns represents the DayOfWeek. This column stores information about recurring sessions that occur on specific days (e.g., Monday, Tuesday). The ...