Skip to main content

Questions tagged [date-format]

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+...
rosi97's user avatar
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 ...
rsp's user avatar
  • 143
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/) ...
lightning_missile's user avatar
-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 ...
Hannington Mambo's user avatar
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: ...
lucaswxp's user avatar
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 ...
Thiago Romam's user avatar
-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.
Sharath's user avatar
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 ...
Caius Jard's user avatar
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 ...
Toni's user avatar
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 ...
Mikey T.K.'s user avatar
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, ...
Bradley Marques's user avatar
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 ...
SlopeOak's user avatar
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 ...
Cdn_Dev's user avatar
-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
user1288329's user avatar
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 ...
Simon Bergot's user avatar

153050per page
close