Gamecommunity =GCHQ= :: View topic - php / sql / unix time stamp

Yeah been a long time. I just cancelled my subscription to WOW. It get's boring when you've done it all, plus the teamwork in PVP isn't as good as the teamwork in DC, BFV, POE, etc...

So, I inallted my copy of Battlefield 2 I bought a year ago, and after tweaking the settings, it's a pretty damn good game. Was in stitches the other night - I forgot how fun BF series was.

I didn't see a BF2 server at GCHQ, just a PoE BF2 server with no one on it! What's going on there? What do you lot play? BF2142? Wouldn't mind killing a few of u lot again, and dying even more...

Author:	happyslappy [ Tue Nov 07, 2006 5:40 pm ]
Post subject:	php / sql / unix time stamp
im storing dates in sql in unix epoch format in a table int(10) its easy to do date validation that way but makes it hard for humans to read in that format. i can convert it back to a date format easy but its in USA format - how do i display it in UK format ?

Author:	gemma=GCHQ= [ Tue Nov 07, 2006 9:37 pm ]
Post subject:
dd/mm/yyyy

Author:	Caspius=GCHQ= [ Tue Nov 07, 2006 10:03 pm ]
Post subject:
Gmar=GCHQ= wrote: dd/mm/yyyy parseDate( "10/2/2006", "%d/%m/%Y" ) /runs away

Author:	Jim Rockford [ Wed Dec 13, 2006 3:13 pm ]
Post subject:
Dunno if you are using Oracle, but I use alter session set nls_date_format to change the format style of a date during my SQL session. Alternatively you can use todate in a select to do a 1 shot conversion. More info here on nls_date_format... http://www.dba-oracle.com/t_nls_date_format_sysdate.htm ...and Don looks like he's great craic too.

Author:	happyslappy [ Wed Dec 13, 2006 3:49 pm ]
Post subject:	ops
cheers - log sorted now but thanks long time no see jim

Gamecommunity =GCHQ= http://82.148.227.125:8080/

php / sql / unix time stamp http://82.148.227.125:8080/viewtopic.php?f=122&t=34968	Page 1 of 1

Author:	Jim Rockford [ Wed Dec 13, 2006 4:25 pm ]
Post subject:
Yeah been a long time. I just cancelled my subscription to WOW. It get's boring when you've done it all, plus the teamwork in PVP isn't as good as the teamwork in DC, BFV, POE, etc... So, I inallted my copy of Battlefield 2 I bought a year ago, and after tweaking the settings, it's a pretty damn good game. Was in stitches the other night - I forgot how fun BF series was. I didn't see a BF2 server at GCHQ, just a PoE BF2 server with no one on it! What's going on there? What do you lot play? BF2142? Wouldn't mind killing a few of u lot again, and dying even more...

Author:	elbow=GCHQ= [ Wed Dec 13, 2006 4:36 pm ]
Post subject:
Moslty CSS these days but there's usually a few of us on DC, and hopefully we'll give COD 2 a kick up the backside in the new year

Author:	happyslappy [ Wed Dec 13, 2006 6:44 pm ]
Post subject:	lo
Quote: Yeah been a long time. I just cancelled my subscription to WOW. It get's boring when you've done it all, plus the teamwork in PVP isn't as good as the teamwork in DC, BFV, POE, etc... So, I inallted my copy of Battlefield 2 I bought a year ago, and after tweaking the settings, it's a pretty damn good game. Was in stitches the other night - I forgot how fun BF series was. I didn't see a BF2 server at GCHQ, just a PoE BF2 server with no one on it! What's going on there? What do you lot play? BF2142? Wouldn't mind killing a few of u lot again, and dying even more... bf2 kinda died off and the poe server is either empty or full - infact i think i need to patch it quite a few play bf2142 but im not sure where be good to kill ya again cya

Page 1 of 1	All times are UTC [ DST ]
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/