SQL Date
#1

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:
Код:
1245843772610
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 ??
Reply
#2

I Know nothing about Javascript Srry, But is that a TIMESTAMP?
Reply
#3

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
Reply
#4

BUMP how do I use timestamp?
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)