IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

New Is there any DB without a current_date function?
If there is a DB (in widespread use) that is missing this builtin, I'd love to know...it has to be accessible from a SELECT to qualify.

Postgres has CURRENT_DATE, CURRENT_TIME
Access has Now()
SQL Server has getdate()
Oracle has SYSDATE
MySQL has CURDATE() and CURTIME()

...others?
Expand Edited by FuManChu April 30, 2004, 02:39:23 PM EDT
New Firebird has CURRENT_DATE, CURRENT_TIME, & CURRENT_TIMESTAMP
New Also: CURRENT_SHILL, CURRENT_CRC, CURRENT_CRCERROR
--
[link|mailto:greg@gregfolkert.net|greg],
[link|http://www.iwethey.org/ed_curry|REMEMBER ED CURRY!] @ iwethey

Give a man a match, he'll be warm for a minute.
Set him on fire, he'll be warm for the rest of his life!
New Ob:Eiks taeae vittun homma nyt riitaeae taestae paeivaestae?
New Nah, didn't mean to accuse you of anything...
Even though I hit home :)

It was supposed to be a joke. But obviously I might be misunderstanding your Ob. As I just read it tothe best ability of what I though it said, withOUT computerizing the translation.

But, then I probably should have fired that off...
--
[link|mailto:greg@gregfolkert.net|greg],
[link|http://www.iwethey.org/ed_curry|REMEMBER ED CURRY!] @ iwethey

Give a man a match, he'll be warm for a minute.
Set him on fire, he'll be warm for the rest of his life!
Expand Edited by folkert May 5, 2004, 10:18:56 PM EDT
New Likewise. (I don't believe in Babelfishing Finnish, BTW. :-)
New Believe even less in Merkins getting Finnish without it! :-)
New Resource Link
Ran across the following [link|http://sqlzoo.net/|SQL Related Link] and though it might be of interest as it has pointers to date handling in some of the various major databases.
New very useful, thanx
Time for Lord Stanley to get a Tan
questions, help? [link|mailto:pappas@catholic.org|email pappas at catholic.org]
New Excellent! Vielen dank
     Is there any DB without a current_date function? - (FuManChu) - (9)
         Firebird has CURRENT_DATE, CURRENT_TIME, & CURRENT_TIMESTAMP -NT - (CRConrad) - (5)
             Also: CURRENT_SHILL, CURRENT_CRC, CURRENT_CRCERROR -NT - (folkert) - (4)
                 Ob:Eiks taeae vittun homma nyt riitaeae taestae paeivaestae? -NT - (CRConrad) - (3)
                     Nah, didn't mean to accuse you of anything... - (folkert) - (2)
                         Likewise. (I don't believe in Babelfishing Finnish, BTW. :-) -NT - (CRConrad)
                         Believe even less in Merkins getting Finnish without it! :-) -NT - (CRConrad)
         Resource Link - (ChrisR) - (2)
             very useful, thanx -NT - (boxley)
             Excellent! Vielen dank -NT - (FuManChu)

Where's web cam sex show Barbie?
69 ms