Mercurial > urweb
diff 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 |
line wrap: on
line diff
--- a/tests/time.ur Thu Oct 30 15:16:37 2008 -0400 +++ b/tests/time.ur Thu Oct 30 15:33:28 2008 -0400 @@ -7,9 +7,9 @@ dml (INSERT INTO t (Id, Time) VALUES (42, {now})); xml <- queryX (SELECT * FROM t) (fn r => <xml>{[r.T.Id]}: {[r.T.Time]}<br/></xml>); - minMax <- oneRow (SELECT MIN(t.Time) AS Min, MAX(t.Time) AS Max FROM t); + minMax <- oneRow (SELECT CURRENT_TIMESTAMP AS Cur, MIN(t.Time) AS Min, MAX(t.Time) AS Max FROM t); return <xml><body> {xml} {[now]}, {[now = now]}, {[now = later]}, {[later < now]}, {[now < later]}<br/> - {[minMax.Min]}, {[minMax.Max]} + {[minMax.Cur]}, {[minMax.Min]}, {[minMax.Max]} </body></xml>