Questions tagged [date-format]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1 vote
3 answers

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
  • 135
1 vote
1 answer

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
1 vote
1 answer

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 ( because I think it suits this project perfectly. Date-fns ( ...
lightning_missile's user avatar
-2 votes
4 answers

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
130 votes
14 answers

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
  • 1,389
1 vote
0 answers

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
-2 votes
1 answer

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
  • 123
13 votes
4 answers

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
4 votes
3 answers

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
  • 53
3 votes
1 answer

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
0 votes
1 answer

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
9 votes
1 answer

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
  • 117
0 votes
2 answers

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 ...
mcraenich's user avatar
  • 263
-1 votes
1 answer

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
0 votes
1 answer

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
  • 7,940
1 vote
2 answers

how to deal with different formats of 'time/date format'?

Different systems accepts different formats of formating time. E.g. java, jquery: yyyy-MM-dd HH:mm some jquery plugins: yy-mm-dd HH:MM momentjs: YYYY-MM-DD HH:mm ISO-8601: YYYY-MM-DD hh:mm etc On ...
Konstantin Petrukhnov's user avatar
0 votes
2 answers

Interpreting Date formats

Let's say I have a DatePicker control and I allow my US clients to type something like "1/1" in it and hit tab go to next control. So I will parse that date for them as "01/01/2014" and some more ...
DevWannaBe's user avatar
1 vote
3 answers

Checking a record is due based on the 'occuring' field

I have records that have dates against them and an occurring field that contains none,yearly and monthly id status note date last_updated occurring 1 open --- 01/01/2011 ...
andy's user avatar
  • 109
2 votes
1 answer

Date & time - apply current, or 'then' DST?

I'm designing a function that given a UTC timestamp will convert it to the local time. The question I have, should the current times DST settings be applied to the conversion, or the timestamps DST ...
Vadim Peretokin's user avatar
133 votes
17 answers

How do you store "fuzzy dates" into a database?

This is a problem I've run into a few times. Imagine you have a record that you want to store into a database table. This table has a DateTime column called "date_created". This one particular record ...
7 votes
2 answers

Is a day really 24 hours long? [closed]

I asked this question on Stack Overflow and it was closed as off-topic. I'll ask it here hoping it will do better. This might sound silly, but bear with me. I've been working a lot with intervals and ...
Radu Potop's user avatar
0 votes
2 answers

How to handle timezone for dates?

With a YYYY-MM-DD HH:MM:SS date I always store the UTC time. When I pull to display I translate timezones with built-in PHP functions and classes. I believe that is one correct way to do it and it ...
Ryan's user avatar
  • 1,645
50 votes
3 answers

Why does Javascript treat days and months differently?

I've noticed that in JavaScript, when creating a Date, months are zero based, and days aren't. For example: var foo = new Date(2012, 1, 1) produces February 1st 2012 Why is this?
shauneba's user avatar
  • 735
3 votes
3 answers

Date calculation algorithm

I'm working on a project to schedule a machine shop, basically I've got everything covered BUT date calculations, I've got a method called schedule (working on PHP here): public function schedule($...
Julian Cuevas's user avatar
-1 votes
2 answers

Ideal "intermediate" file format to use for structured/styled text? [closed]

I have files that I want to make available in an variety of formats: HTML PDF EPUB Plain Text (maybe) Most of the files will be sourced in doc, docx, or rtf format, so that needs to be considered. ...
Jordan Reiter's user avatar
15 votes
7 answers

Is there a constant for "end of time"?

For some systems, the time value 9999-12-31 is used as the "end of time" as the end of the time that the computer can calculate. But what if it changes? Wouldn't it be better to define this time as a ...
Niklas Rosencrantz's user avatar
3 votes
2 answers

Which timezone is used for permalinks of posts [closed]

I wanted to add timezone support to my blog app but got stuck with a design problem. Every post has a published_on field which stores the publication date in a timezone aware format (UTC converted to ...
sbaechler's user avatar
  • 149
0 votes
6 answers

International two-part date formats

Do people outside of the USA use two-part date abbreviations for the current year? For instance, representing the last day of May, you might see someone enter 5/31 into a date field. Do international ...
Dov's user avatar
  • 135
11 votes
3 answers

Should I use the Date type in JAX-RS @PathParam?

This is what I'm thinking about doing on a JEE Glassfish server using Jersey. @GET @Path("/{name}/{date}") public String getMessages(@PathParam("name") String name, @PathParam("date") Date date) I ...
Jazzepi's user avatar
  • 494
6 votes
3 answers

Best representation for relative dates & durations

I use ISO 8601 to represent dates & durations and all is OK. But now I need to represent relative dates and durations like: The date for first day, at midnight, of the next week All the last ...
philnext's user avatar
  • 173
30 votes
12 answers

isn't number localization just unnecessary?

I've just read this page One of the things they did was to convert the arabic date to the arabic ...
Pacerier's user avatar
  • 4,973
13 votes
11 answers

Is there a universal date format that anyone in the world can understand?

In Canada, everyone is familiar with the date format YYYY-MM-DD. In Europe or South Africa, they prefer DD-MM-YYYY. There are users from South Africa who get confused with the YYYY-MM-DD date format....
Thierry Lam's user avatar
  • 1,108