The Wiert Corner – irregular stream of stuff

Jeroen W. Pluimers on .NET, C#, Delphi, databases, and personal interests

  • My badges

    Mastodon

  • Twitter Updates

  • My Flickr Stream

    20140508-Delphi-2007--Project-Options--Cannot-Edit-Application-Title-HelpFile-Icon-Theming20140430-Fiddler-Filter-Actions-Button-Run-Filterset-now20140424-VMware-Fusion-6.0.3.-no-reclaimable
    More Photos

  • Pages

  • All categories

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 1,858 other subscribers
«
»

Date format converter from Text or Unix/Mac/Filetime/Microsoft to virtually any readable form

Posted by jpluimers on 2017/02/09

Brilliant Date format converter from dates in Text (almost any format) or timestamp numbers in Unix, Mac, Filetime or Microsoft (which is the same as Delphi TDateTime) format to any of these formats:

Text Date:
Date in human-readable text		 Wednesday, March 23, 2016 4:05:39pm
RFC 822:
RFC 822 formatted date		 Wed, 23 Mar 2016 16:05:39 +0000
ISO 8601:
ISO 8601 formatted date		 2016-03-23T16:05:39+00:00
UNIX Timestamp:
seconds since Jan 1 1970		 1458749139
Mac Timestamp:
seconds since Jan 1 1904		 3541593939
Microsoft Timestamp:
days since Dec 31 1899		 42452.670590278
FILETIME:
100-nanoseconds since Jan 1 1601		 131032227390000000
01D1851D:D7B58B80

Source: Date format converter

–jeroen

This entry was posted on 2017/02/09 at 06:00 and is filed under *nix, .NET, Apple, Delphi, Development, Mac, Mac OS X / OS X / MacOS, Power User, Software Development. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “Date format converter from Text or Unix/Mac/Filetime/Microsoft to virtually any readable form”

  1. Firebird – adjusting Delphi stored TDateTime (or OLE Automation date) fields that contain Dates, Times or DateTimes « The Wiert Corner – irregular stream of stuff said

    2017/02/15 at 06:00

    […] post is complementary to Date format converter from Text or Unix/Mac/Filetime/Microsoft to virtually any readable form (which mentions the wrong Microsoft epoch as it should be 1899-12-30 midnight): the above shows […]

    Reply

Leave a reply to Firebird – adjusting Delphi stored TDateTime (or OLE Automation date) fields that contain Dates, Times or DateTimes « The Wiert Corner – irregular stream of stuff Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

«
»