Questions tagged [date-format]
The date-format tag has no summary.
32 questions
1vote
3answers
2kviews
Parse 8 bytes to date time
I am trying to parse a file created by another software, but I cant identify a pattern on how this datetime is saved. There doesnt seem to be any consistency. Programming language of the software is C+...
1vote
1answer
261views
Correct format to receive datatime data from consumer
I am working on a service in a sprint boot microservice application. The consumer for my service can be another service, as well as a UI component. The are 5 entities in my service, each entity having ...
1vote
1answer
128views
How to manage 2 libraries that do mostly the same things in a project?
I am encountering a design problem on a new project. I have chosen the library Luxon (https://moment.github.io/luxon/) because I think it suits this project perfectly. Date-fns (https://date-fns.org/) ...
-2votes
4answers
473views
Is Date a String or a complex object?
It is my first post here and I thought it really fits on this side than on the regular website. I am sure many of you (programmers) must have had nightmares with this Date 'object', either in your ...
128votes
14answers
43kviews
Is there any technical reason why, in programming, the default date format is YYYYMMDD and not something else?
Is there any engineering reason why is it like that? I was wondering in the case of a RDBMS that it had something to do with performance, since a "YEAR" is more specific than a "MONTH", for instance: ...
1vote
0answers
251views
Working with user timezones in the web browser and reports generated in the back-end
I have searched a lot on how to handle timezone in a web app. My application saves all dates as UTC in the database and returns UTC dates in json requests, so javascript proper handle conversions in ...
-2votes
1answer
122views
What is the preferable date-format used for designing APIs and storage
The date format should support different timezone and Daylight saving issues.
13votes
4answers
769views
About my database date datatype crusade: Valid? Worthwhile? Does anyone else feel it?
I spend a lot of time answering SQL questions over on SO. I frequently come across queries of this ilk: SELECT * FROM person WHERE birthdate BETWEEN '01/01/2017' AND '01/03/2017' SELECT * FROM ...
4votes
3answers
8kviews
Working with timezones when storing dates in mysql
I have just a basic site with registration. With all other data, it stores the registration date in MySQL. If I'm in USA or in Canada, and I register at 2017-03-07 (Y-d-m), in MySQL it's 2017-04-07 ...
4votes
1answer
521views
Optimal format for storing key/value data optimized for quick key lookup
For a completely fun project, I want to write a Markov chain chat bot. The algorithm used is quite simple - break down incoming sentences into tokens, storing what words tend to come after each token ...
0votes
1answer
65views
Historic (and prehistoric) dates in Ruby [closed]
In Ruby, is there a standard class or gem to work with dates that can be - but are not required to be - historical in nature? The dates have precision (to the nearest million years, decade, century, ...
9votes
1answer
4kviews
What is the difference between "kk" and "HH"+1 in ISO-8601?
In the ISO-8601 there are multiple hour formats, one of them is "kk" for hours 1-24. What is the purpose of this? Are there countries that offset their time? Is it for military usages? The ...
0votes
2answers
1kviews
Dealing with date fields across browsers
I'm building a web application with multiple forms which all require date fields, and these fields need to be supported across IE, Chrome, and the like. Our application currently packages the output ...
-1votes
1answer
16kviews
Groovy date/time compare [closed]
I have this string got from JIRA as the date/time I need to compare which one is earlier:"21/Sep/12 2:01 PM". How can I do this in Groovy? Thanks Jirong
0votes
1answer
34views
standard format to describe opening schedules
I am working on a project in which I have to model opening schedules (eg a swimming pool is opened from 10:30am to 5pm on Tuesday from january to May. I try to fit this data in a csv and I started ...