Firebird
get rows of dynamic latest date(s)
…. sorry for not updating for such a long time.
just got a mail from a friend recently. probably this is some idea to share:
—
yo, Byeol. got a problem here. I have a table (FB) where I need to store every month’s stock of any available Product:
CREATE TABLE TSTOCK (
THEDATE DATE NOT NULL,
PRODUCTID VARCHAR(30) NOT NULL,
COST DOUBLE PRECISION [...]
get current date time in Firebird?
a friend asked me:
hi, do you know how to get current date time directly from firebird sql? I need to make sure that every client that append or insert any data would use or access the same date time resource, I would like to use sql date time directly, because some of the clients would [...]
SQL tips for ’select limit’ in Firebird DB
a friend asked me about how to do the similar things like this one (of MySQL), but in Firebird DB:
select limit … from foo
something like that. and as far as I know, the equivalent SQL should be like this one, at least this works in Firebird 1.5:
select
[...]
Date Time simple tips for Firebird store procedure
okay, first … I would like to admit that I’m quite a newbie in Firebird database. I used MySQL back then but few months ago my employer wanted to migrate to Firebird and up till now, we still remain using Firebird 1.5 for certain reasons. quite a headache for me because this one was totally [...]
Read Full Post | Make a Comment ( 5 so far )
