Professional Web Applications Themes

GMTime equivalent in SQL - Microsoft SQL / MS SQL Server

Hi there, is there an equvalent function in SQL Server like the C GMTime to convert the numbers of seconds since 01/01/1970 to a datetime value?...

  1. #1

    Default GMTime equivalent in SQL

    Hi there,
    is there an equvalent function in SQL Server like the C GMTime
    to convert the numbers of seconds since 01/01/1970 to a datetime value?


    Waldy Guest

  2. Moderated Post

    Default Re: GMTime equivalent in SQL

    Removed by Administrator
    Tibor Guest
    Moderated Post

  3. #3

    Default Re: GMTime equivalent in SQL

    Use DATEADD:

    DECLARE t INTEGER
    SET t = 1061424000

    SELECT DATEADD(SECOND,t,'19700101')


    Result:

    ------------------------------------------------------
    2003-08-21 00:00:00.000

    (1 row(s) affected)


    --
    David Portas
    ------------
    Please reply only to the newsgroup
    --


    David Guest

Similar Threads

  1. SUN N1 equivalent
    By yls177 in forum Linux / Unix Administration
    Replies: 3
    Last Post: December 24th, 04:12 PM
  2. PHP equivalent to MOD
    By James Johnson in forum PHP Development
    Replies: 1
    Last Post: August 30th, 07:27 PM
  3. php equivalent of CGI.pm
    By pittendrigh in forum PHP Development
    Replies: 1
    Last Post: August 19th, 02:45 PM
  4. ACT! Equivalent for Mac?
    By compuser in forum Mac Applications & Software
    Replies: 2
    Last Post: July 10th, 05:34 PM
  5. localtime/mktime = gmtime/???
    By Markus Breuer in forum Sun Solaris
    Replies: 1
    Last Post: July 10th, 11:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139