| Author |
Message |
|
happyslappy
|
Post subject: php / sql / unix time stamp  Posted: Tue Nov 07, 2006 5:40 pm |
|
 |
| that was a stupid comment btw |
 |
Joined: Wed Mar 03, 2004 12:40 pm
Posts: 109344
Location: manchester
|
|
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 ?
_________________ 
|
|
  |
|
 |
|
gemma=GCHQ=
|
Post subject: Posted: Tue Nov 07, 2006 9:37 pm |
|
|
| Made in Taiwan |
 |
Joined: Sun Apr 11, 2004 9:14 pm
Posts: 3549
Location: Bonneville salt flats.
|
|
dd/mm/yyyy
_________________
Don't worry Sony, I'll just cancel my date of birth and get a new one.
|
|
| |
|
|
|
Caspius=GCHQ=
|
Post subject: Posted: Tue Nov 07, 2006 10:03 pm |
|
|
| The Groundkeeper |
 |
Joined: Fri Mar 26, 2004 7:59 pm
Posts: 6056
Location: UK
|
Gmar=GCHQ= wrote: dd/mm/yyyy
 parseDate( "10/2/2006", "%d/%m/%Y" )
/runs away _________________ 
|
|
| |
|
|
|
Jim Rockford
|
Post subject: Posted: Wed Dec 13, 2006 3:13 pm |
|
|
|
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.
|
|
| |
|
|
|
happyslappy
|
Post subject: ops Posted: Wed Dec 13, 2006 3:49 pm |
|
|
| that was a stupid comment btw |
|
Joined: Wed Mar 03, 2004 12:40 pm
Posts: 109344
Location: manchester
|
cheers - log sorted now but thanks 
long time no see jim _________________
|
|
| |
|
|
|
Jim Rockford
|
Post subject: Posted: Wed Dec 13, 2006 4:25 pm |
|
|
|
|
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...
|
|
| |
|
|
|
elbow=GCHQ=
|
Post subject: Posted: Wed Dec 13, 2006 4:36 pm |
|
|
| Comin' outta Gallifrey |
 |
Joined: Mon Aug 01, 2005 9:44 pm
Posts: 7821
Location: banging with enamor
|
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
_________________
“There are some people in this world who don’t love their fellow man, and I HATE people like that!”
|
|
| |
|
|
|
happyslappy
|
Post subject: lo Posted: Wed Dec 13, 2006 6:44 pm |
|
|
| that was a stupid comment btw |
|
Joined: Wed Mar 03, 2004 12:40 pm
Posts: 109344
Location: manchester
|
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 _________________
|
|
| |
|
|
|
