The Tridecadal Korean (astralblue) wrote,
The Tridecadal Korean
astralblue

… ♥♥♥

ab=> SELECT s.name, l.locality, s.startsAt, s.duration FROM schedule s JOIN locations l ON s.location = l.id WHERE s.name LIKE 'Eugene %'1 AND startsAt >= '20080722T1600-04' AND s.startsAt + s.duration <= '20080731T1500-04' ORDER BY s.startsAt, s.name;
    name    | locality |        startsat        |    duration     
------------+----------+------------------------+-----------------
 Eugene Lee | Chicago  | 2008-07-22 16:25:00-04 | 01:35:00
 Eugene Kim | Chicago  | 2008-07-22 16:40:00-04 | 01:20:00
 Eugene Kim | New York | 2008-07-22 20:30:00-04 | 8 days 11:30:00
 Eugene Lee | New York | 2008-07-22 20:30:00-04 | 8 days 11:30:00
 Eugene Kim | Chicago  | 2008-07-31 10:35:00-04 | 03:35:00
 Eugene Lee | Chicago  | 2008-07-31 10:35:00-04 | 03:15:00
(6건 있음)
ab=>

: )


1 XDD

Tags: love
Subscribe

  • Post a new comment

    Error

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.
  • 2 comments