Showing posts with label timstamp. Show all posts
Showing posts with label timstamp. Show all posts

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