Results 1 to 6 of 6

Thread: DateDiff and SQL sort

Threaded View

  1. Feb 19th, 2005, 08:45 PM #1
    x-ice
    x-ice is offline

    Thread Starter
    Fanatic Member x-ice's Avatar
    Join Date
    Mar 2004
    Location
    UK
    Posts
    671

    Resolved DateDiff and SQL sort

    Firstly i want to use DateDiff to establish the amount of time between a Login and Logout time? Can this be done? and what values can DateDiff return?

    Also, how can i sort by Date using if i'm using an SQL statement? When i try to do this only the first segment of the date is sorted, but everything after the first slash isn't sorted. How can i sort using the whole date?

    thanks
    Last edited by x-ice; Feb 26th, 2005 at 08:01 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width