SQL Date - Printable Version
+- SA-MP Forums Archive (
https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (
https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (
https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (
https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: SQL Date (
/showthread.php?tid=84221)
SQL Date -
Ignas1337 - 29.06.2009
i'm working on a jail system which has 'jail_time' table in my database and i want to know how could i manipulate this format of date:
it's from this code of my previous lineage2 server database, it displays the date character was last used (got logged in)
Код:
izanagi 268471337 Izanami 80 3034 3034 1517 1517 2695 2695 33 40 33 3 47 213 4 72 330 126 88 21 25 24 37 40 23 2 0 0 1 14220 147346 11293 -800 1 1 9 23 6299994998 0 2147483647 0 43 82 0 192510000 1 103 103 0 0 Okami 255 9 200 0 154430 1 1245843772610 0 0 0 0 0 0 1 0 1245060000310 1 0 0 0 0 0 0 0 0
I do not want to mess with the source and as I am not very good at java script anyway (since this game server is based on java (l2j).. )
Well anyway, how could I get the time in that format and how do I get it to like Year/Month/Day Hour:Minutes:Seconds ??
Re: SQL Date -
[nl]daplayer - 29.06.2009
I Know nothing about Javascript Srry, But is that a TIMESTAMP?
Re: SQL Date -
Ignas1337 - 29.06.2009
I beleave it is. even if it's not I need something that can store entire date in a single string/whatever. I beleave it is timestamp
Re: SQL Date -
Ignas1337 - 29.06.2009
BUMP how do I use timestamp?