Wednesday, March 05, 2008

insert one blog post into database

INSERT INTO POSTS (ID, TITLE, BODY, CREATED, MODIFIED)
VALUES (
null,
'Foo',
'bar',
'now',
'now'
)

and do an select

SELECT a.ID, a.TITLE, a.BODY, a.CREATED, a.MODIFIED
FROM POSTS a


'now' is an predefined timestamp literal in firebird

No comments: