Mercurial > urweb
comparison tests/time.ur @ 441:c5335613f31e
CURRENT_TIMESTAMP
| author | Adam Chlipala <adamc@hcoop.net> |
|---|---|
| date | Thu, 30 Oct 2008 15:33:28 -0400 |
| parents | 19d7f79cd584 |
| children |
comparison
equal
deleted
inserted
replaced
| 440:19d7f79cd584 | 441:c5335613f31e |
|---|---|
| 5 | 5 |
| 6 fun main () = | 6 fun main () = |
| 7 dml (INSERT INTO t (Id, Time) VALUES (42, {now})); | 7 dml (INSERT INTO t (Id, Time) VALUES (42, {now})); |
| 8 xml <- queryX (SELECT * FROM t) | 8 xml <- queryX (SELECT * FROM t) |
| 9 (fn r => <xml>{[r.T.Id]}: {[r.T.Time]}<br/></xml>); | 9 (fn r => <xml>{[r.T.Id]}: {[r.T.Time]}<br/></xml>); |
| 10 minMax <- oneRow (SELECT MIN(t.Time) AS Min, MAX(t.Time) AS Max FROM t); | 10 minMax <- oneRow (SELECT CURRENT_TIMESTAMP AS Cur, MIN(t.Time) AS Min, MAX(t.Time) AS Max FROM t); |
| 11 return <xml><body> | 11 return <xml><body> |
| 12 {xml} | 12 {xml} |
| 13 {[now]}, {[now = now]}, {[now = later]}, {[later < now]}, {[now < later]}<br/> | 13 {[now]}, {[now = now]}, {[now = later]}, {[later < now]}, {[now < later]}<br/> |
| 14 {[minMax.Min]}, {[minMax.Max]} | 14 {[minMax.Cur]}, {[minMax.Min]}, {[minMax.Max]} |
| 15 </body></xml> | 15 </body></xml> |