java - Ordinal hour-of-day "Hour Ending" conversion to date-time value -


some businesses track events in time "hour ending". each hour of day represented ordinal number:

  • 1…24 utc
  • 1…23, 1…24, , 1…25 time zones one-hour daylight saving time (dst) adjustment.

so first hour of day, midnight 01:00 hour ending 01.

to me, seems silly way track time. more sensible using time-of-day half-open approach, [), beginning inclusive, , ending exclusive. so:

  • 2014-12-05t01:00:00.000 mark hour ending 01
  • 2014-12-06t00:00:00.000 (midnight) mark hour ending 24.

indeed, want store in database (postgres), timestamp time zone value converted date & ordinal hour number. question is:

given date , ordinal "hour ending" number (1…23/24/25 locality 1-hour dst), how convert date-time value?

i'm familiar joda-time , java.time. either of them offer way convert? if not, kind of algorithm handles both ordinal number conversion , dst?

or should not fight this, , store local date string suffix of ordinal hour number?

perhaps java.time method looking truncatedto, can used take zoneddatetime , truncate minutes , seconds

zoneddatetime zdt = zoneddatetime.now(); zoneddatetime rounded = zdt.truncatedto(chronounit.hours); zoneddatetime hourend = rounded.plushours(1); 

Comments

Popular posts from this blog

python - mat is not a numerical tuple : openCV error -

c# - MSAA finds controls UI Automation doesn't -

wordpress - .htaccess: RewriteRule: bad flag delimiters -