?

Log in

No account? Create an account
Eyes

… ♥♥♥

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:

Comments

DROP database `schedule`; lawl
You forgot “--” before the lawl XD!