Evening all.

My favoured method of timestamping is YYYYMMDDHHMMSS, does anyone know if this timestamp type has a specific name?

I'm writing a class to manipulate this timestamp type and would like to call it by its correct moniker.

thanks
jfp

Dunno ....  English isn't my strong point  

I've a pile of MySQL books here and I've had a look through a few of them and there's no one descriptor word that looks "official" in any of them so far .... how about calling it "sortable14" format and you are VERY welcome to reject my suggestion cos I don't really like that solution .....

yeah, I've done the digging and searching too, and alas, not answer!

<quote>
how about calling it "sortable14" format and you are VERY welcome to reject my suggestion
</quote>
Suggestion rejected  

Is this the timestamp you use? I find this so easy to sort my results on  in comparison to the others.

When I finish the PHP class I'll stick it on the Forum, sure others will find a use for it.

jfp

I await (with baited breath) to find out what you call your class  

I call mine mysql_datetime, but because of the different sizes then adding the 14 would clarify which accuracy you are using.

By the way did you know that you can insert todays date inside the query using now() :-
"INSERT ..... now()  ...".
And outside the query and inside PHP you can use time(). Although it gives a timestamp, mysql recognises it and converts it for you.

---