diff options
author | Benjamin Barenblat <bbaren@mit.edu> | 2017-07-23 09:50:04 -0400 |
---|---|---|
committer | Benjamin Barenblat <bbaren@mit.edu> | 2017-07-23 09:50:04 -0400 |
commit | 0cccdb0ae595cd7e3e136e984ac7b95b99f71a53 (patch) | |
tree | 491d3b13813610943c60460d3e178d3a73916346 /tests/time.ur |
Import urweb_20170720+dfsg.orig.tar.gz
[dgit import orig urweb_20170720+dfsg.orig.tar.gz]
Diffstat (limited to 'tests/time.ur')
-rw-r--r-- | tests/time.ur | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/tests/time.ur b/tests/time.ur new file mode 100644 index 0000000..8676c48 --- /dev/null +++ b/tests/time.ur @@ -0,0 +1,15 @@ +table t : { Id : int, Time : time } + +val now : time = readError "10/30/08 14:35:42" +val later : time = readError "10/30/08 14:37:42" + +fun main () = + 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 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.Cur]}, {[minMax.Min]}, {[minMax.Max]} + </body></xml> |