diff options
| author |  Adam Chlipala <adamc@hcoop.net> | 2008-10-30 15:33:28 -0400 |
|---|---|---|
| committer | Adam Chlipala <adamc@hcoop.net> | 2008-10-30 15:33:28 -0400 |
| commit | b1710b4191841176fa84a2d7e10cabcf1d048bb4 (patch) | |
| tree | b3af420e0116388b43fc38752a344cbd9ed04b32 /tests/time.ur | |
| parent | d710cc7a5aa246763af96dfca57ec8a7a5a6fd37 (diff) | |
CURRENT_TIMESTAMP
Diffstat (limited to 'tests/time.ur')
| -rw-r--r-- | tests/time.ur | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/tests/time.ur b/tests/time.ur index f81c59c3..8676c48f 100644 --- a/tests/time.ur +++ b/tests/time.ur @@ -7,9 +7,9 @@ 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 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> |