How can I convert a Julian (1970) time value to a standard date and time format?


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 4 of 4

Thread: How can I convert a Julian (1970) time value to a standard date and time format?

  1. #1
    Join Date
    May 2005
    Posts
    1

    Angry How can I convert a Julian (1970) time value to a standard date and time format?

    I am a newbie that is trying to convert a Julian (1970) time value to a standard current date and time format. An example of the value (the number of seconds since Jan 1, 1970 00:00:00.000) that I am trying to convert:

    1104537622 = Jan 1, 2005 00:00:00.000

    Any help would be greatly appriciated.
    Last edited by talonman; 05-12-2005 at 10:39 AM.

  2. #2
    Join Date
    Jun 2004
    Location
    Houston area
    Posts
    557
    What is the date and what format would you LIKE it to be in? There are SEVERAL options here.

    L
    A balanced diet is a cookie in each hand.

  3. #3
    Join Date
    Dec 2003
    Posts
    2,750
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

  4. #4
    Join Date
    Dec 2003
    Posts
    2,750
    I noticed you posted a duplicate message of this post. That post has been removed.

    Please post follow-ups in the current thread - don't start new ones for the same topic.

    Just to follow-up I'm not sure exactly what you're trying to do. If you want to determine a target date given a start date and time interval you can use the DateAdd function:

    DateResult = DateAdd("s", 1104537622, "01/01/1970")
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center