Loading ...
Sorry, an error occurred while loading the content.
 

Date difference between two dates.

Expand Messages
  • sunil john
    Dear all, How can get difference between two date in sql 2000. say my startdate is 2008-01-01 00:00:43.753 and enddate is 2008-01-01 00:00:44.783 . i want
    Message 1 of 2 , Sep 2, 2008
      Dear all,

      How can get difference between two date in sql 2000.
      say my startdate is '2008-01-01 00:00:43.753' and enddate is '2008-01-01 00:00:44.783'. i want the difference even to millisecond also. Please guide me with all the ways to do this.

      Best Regards


      Sunil John



      Get your preferred Email name!
      Now you can @... and @....
      http://mail.promotions.yahoo.com/newdomains/aa/

      [Non-text portions of this message have been removed]
    • Madhu K Nair
      Check this select datediff(ms, 2008-01-01 00:00:43.753 , 2008-01-01 00:00:44.783 ) Madhu ... 01-01 00:00:44.783 . i want the difference even to millisecond
      Message 2 of 2 , Sep 2, 2008
        Check this
        select datediff(ms,'2008-01-01 00:00:43.753' ,'2008-01-01
        00:00:44.783')

        Madhu

        --- In sqlcon@yahoogroups.com, sunil john <suniljk7@...> wrote:
        >
        > Dear all,
        >
        > How can get difference between two date in sql 2000.
        > say my startdate is '2008-01-01 00:00:43.753' and enddate is '2008-
        01-01 00:00:44.783'. i want the difference even to millisecond also.
        Please guide me with all the ways to do this.
        >
        > Best Regards
        >
        >
        > Sunil John
        >
        >
        >
        > Get your preferred Email name!
        > Now you can @... and @....
        > http://mail.promotions.yahoo.com/newdomains/aa/
        >
        > [Non-text portions of this message have been removed]
        >
      Your message has been successfully submitted and would be delivered to recipients shortly.