Mercurial > urweb
annotate tests/time.ur @ 439:322c8620bbdf
Marshaling time to SQL
| author | Adam Chlipala <adamc@hcoop.net> |
|---|---|
| date | Thu, 30 Oct 2008 15:11:37 -0400 |
| parents | 1c27f03d9bd2 |
| children | 19d7f79cd584 |
| rev | line source |
|---|---|
| adamc@438 | 1 table t : { Id : int, Time : time } |
| adamc@438 | 2 |
| adamc@436 | 3 val now : time = readError "10/30/08 14:35:42" |
| adamc@437 | 4 val later : time = readError "10/30/08 14:37:42" |
| adamc@436 | 5 |
| adamc@438 | 6 fun main () = |
| adamc@439 | 7 dml (INSERT INTO t (Id, Time) VALUES (42, {now})); |
| adamc@438 | 8 xml <- queryX (SELECT * FROM t) |
| adamc@438 | 9 (fn r => <xml>{[r.T.Id]}: {[r.T.Time]}<br/></xml>); |
| adamc@438 | 10 return <xml><body> |
| adamc@438 | 11 {xml} |
| adamc@438 | 12 {[now]}, {[now = now]}, {[now = later]}, {[later < now]}, {[now < later]} |
| adamc@438 | 13 </body></xml> |