How to do date time comparison

Question

Is there any options in doing date comparison in Go  I have to sort data based on date and time - independently  So I might allow an object that occurs within a range of dates so long as it also occurs within a range of times  In this model  I could not simply just select the oldest date  youngest time latest date  latest time and Unix   seconds compare them  I d really appreciate any suggestions   Ultimately  I wrote a time parsing string compare module to check if a time is within a range  However  this is not faring to well  I ve got some gaping issues  I ll post that here just for fun  but I m hoping there s a better way to time compare   package main  import        strconv       strings     func tryIndex arr   string  index int  def string  string       if index  lt   len arr -1           return arr index            return def          Takes two strings of format  hh mm ss  and compares them     Takes a function to compare individual sections  split by          Note  strings can actually be formatted like  h    hh    hh m       hh mm   etc  Any missing parts will be added lazily      func timeCompare a  b string  compare func int  int   bool  bool   bool       aArr    strings Split a           bArr    strings Split b              Catches margins      if  b    a            return true           for i    range aArr           aI       strconv Atoi tryIndex aArr  i   00            bI       strconv Atoi tryIndex bArr  i   00            res  flag    compare aI  bI          if res               return true           else if flag      Needed to catch case where a  gt  b and a is the lower limit             return false                     return false    func timeGreaterEqual a  b int   bool  bool   return a  gt  b  a  lt  b  func timeLesserEqual a  b int   bool  bool   return a  lt  b  a  gt  b         Returns true for two strings formmated  hh mm ss      Note  strings can actually be formatted like  h    hh    hh m       hh mm   etc  Any missing parts will be added lazily      func withinTime timeRange  time string  bool       rArr    strings Split timeRange   -       if timeCompare rArr 0   rArr 1   timeLesserEqual            afterStart    timeCompare rArr 0   time  timeLesserEqual          beforeEnd    timeCompare rArr 1   time  timeGreaterEqual          return afterStart  amp  amp  beforeEnd              Catch things like  timeRange     22 00 00-04 59 59   which will happen        with UTC conversions from local time         THIS IS THE BROKEN PART I BELIEVE     afterStart    timeCompare rArr 0   time  timeLesserEqual      beforeEnd    timeCompare rArr 1   time  timeGreaterEqual      return afterStart    beforeEnd     So TLDR  I wrote a withinTimeRange range  time  function but it s not working totally correctly   In fact  mostly just the second case  where a time range crosses over days is broken  The original part worked  I just realized I d need to account for that when making conversions to UTC from local    If there s a better  preferably built in  way  I d love to hear about it   NOTE  Just as an example  I solved this issue in Javascript with this function   function withinTime start  end  time        var s   Date parse  01 01 2011   start       var e   Date parse  01 0   end   24 00 00   2   1     2011    end   24 00 00   00 00 00  end        var t   Date parse  01 01 2011   time       return s  lt   t  amp  amp  e  gt   t      However I really want to do this filter server-side

User · Answer

For comparison between two times use time Sub       utc life loc       time LoadLocation  UTC       setup a start and end time createdAt    time Now   In loc  Add 1   time Hour  expiresAt    time Now   In loc  Add 4   time Hour      get the diff diff    expiresAt Sub createdAt  fmt Printf  Lifespan is   v   diff    The program outputs   Lifespan is 3h0m0s   http   play golang org p bbxeTtd4L6

User · Answer

Recent protocols prefer usage of RFC3339 per golang time package documentation       In general RFC1123Z should be used instead of RFC1123 for servers that insist on that format  and RFC3339 should be preferred for new protocols  RFC822  RFC822Z  RFC1123  and RFC1123Z are useful for formatting  when used with time Parse they do not accept all the time formats permitted by the RFCs     cutOffTime       time Parse time RFC3339   2017-08-30T13 35 00Z      POSTDATE is a date time field in DB  datastore  query    datastore NewQuery  db   Filter  POSTDATE  gt     cutOffTime

User · Answer

Use the time package to work with time information in Go      Time instants can be compared using the Before  After  and Equal   methods  The Sub method subtracts two instants  producing a Duration    The Add method adds a Time and a Duration  producing a Time    Play example   package main  import        fmt       time     func inTimeSpan start  end  check time Time  bool       return check After start   amp  amp  check Before end     func main         start       time Parse time RFC822   01 Jan 15 10 00 UTC       end       time Parse time RFC822   01 Jan 16 10 00 UTC        in       time Parse time RFC822   01 Jan 15 20 00 UTC       out       time Parse time RFC822   01 Jan 17 10 00 UTC        if inTimeSpan start  end  in            fmt Println in   is between   start   and   end                  if  inTimeSpan start  end  out            fmt Println out   is not between   start   and   end

User · Answer

For case when your interval s end it s date without hours like   from 2017-01-01 to whole day of 2017-01-16  it s better to adjust interval s to 23 hours 59 minutes and 59 seconds like   end   end Add time Duration 23 time Hour    time Duration 59 time Minute    time Duration 59 time Second     if now After start   amp  amp  now Before end

User · Answer

The following solved my problem of converting string into date   package main  import        fmt       time     func main         value      Thu  05 19 11  10 47PM         Writing down the way the standard time would look like formatted our way     layout     Mon  01 02 06  03 04PM      t       time Parse layout  value      fmt Println t          gt   Thu May 19 22 47 00  0000 2011    Thanks to paul adam smith

[datetime] How to do date/time comparison

Examples related to datetime

Examples related to go

Examples related to datetime-comparison