No respose from "SELECT datetime('now');"

[JustVoodoo]

I tried it with SQLiteBrowser an it works.

The logile says "o Got request: SELECT datetime('now','localtime');" but I do not get a response...

A work around is to make an entry for the Date and then "select * FROM x WHERE Id=1" or s.t. like that, but isn't there a way to get that response?

BTW: Does anyone knows a solution for that strftime('%s', 'now') problem? The % will be replaced with ~ and thats pretty bad. Especially because I need the current Day of the Week ( strftime('%W', 'now') ) ...

Any other ways to get the Day of the Week will be fine as well

Thx for Help

[Lokey]

SELECT NOW(); is date + time
SELECT TIME();
SELECT DATE();

Unix time functions can be useful too.

http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html
_________________
Neversummer PW NWNx powered mayhem

[JustVoodoo]

Hi Lokey,

thx for your answer but I guess that that functons are for MySQL not for SQLite. Even in QueryBrowser it says "no such function".

Or is that a function from NWNX (that translate this into SELECT datetime('now') ?).


BTW:
I did the workaround just a few minutes ago. Since I needed some other timefunctions like strftime('%s','now') and strftime('%W','now') and you can't use "%" in a string in NWScript (because some mechanics I dont know translate every "%" in "~", there is another topic about that issue).

So I am using a TRIGGER like this:

[Lokey]

Sorry reading fail. There's certainly sqlite manuals around, spitting out time shouldn't be too hard (failing that there's other modules that give access to environment).
_________________
Neversummer PW NWNx powered mayhem