Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2001
    Location
    South Africa
    Posts
    33

    Unanswered: datetime calculation sql ?

    HI ALL,

    I have a datwetime sql question :

    I have a date and time in the format : 20030101 12:00:00.098

    and I want to do a date calculation : like :
    20030101 12:00:01.000 - 20030101 12:00:00.000

    Is there a way using SQL ??
    Thanks

  2. #2
    Join Date
    Feb 2003
    Posts
    17

    Re: datetime calculation sql ?

    Originally posted by tag
    HI ALL,

    I have a datwetime sql question :

    I have a date and time in the format : 20030101 12:00:00.098

    and I want to do a date calculation : like :
    20030101 12:00:01.000 - 20030101 12:00:00.000

    Is there a way using SQL ??
    Thanks
    Where are you getting the values from?

  3. #3
    Join Date
    Nov 2001
    Location
    South Africa
    Posts
    33

    Re: datetime calculation sql ?

    Originally posted by progress
    Where are you getting the values from?
    I am getting them from a application - it generates the datetime.

  4. #4
    Join Date
    Feb 2003
    Posts
    17

    Re: datetime calculation sql ?

    Originally posted by tag
    I am getting them from a application - it generates the datetime.
    Think you could find enough information here about this:

    http://www.mysql.com/doc/en/Date_calculations.html

Posting Permissions

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