TIMESTAMP formatting?

Anon

I have my primary key set as TIMESTAMP (14)...

When I pull it from the database, it displays in this format:

20010614142833

How can I format it to display in this format:

2000-10-06-14 14:28:33

all help appreciated...

Anon

Depends on the database you are using. All of them seem to have some kind of format() command to format dates. Look in the function documentation for it.

Typically it's something like:

select format(time_field, "%Y-%m-$d %HH:%MM:%SS") from table

but it all depends on the database that you are using as to how it's function works.

Anon

I'm using MySQL... if that helps...

toma42

AxsDeny: use the mysql function
int unix_timestamp(datetime)

this will return a timestamp which you can manipulate easily with the php function date()

[deleted]

you could also let MySQL format the date for you, saves time in PHP.

Anon

That's what I would like it to do, how do I make MySQL format it? I'm not familiar with the formating technique.

Anon

I really hate to say RTFM because it sounds so negative, but this really is a simple problem to solve. The MySQL manual has a very detailed explaination on how to format dates in the SQL statement using the date_format() function.

Like I said in my first post you will do something like:

select date_format(post_date, '%M %D, %Y %H:%i:s') as post_date from table

That will get you a time stamp that looks like this:

June 12th, 2001 17:09:18

But there are many ways to format a timestamp using the date_format() function so read the manual at http://www.mysql.com/documentation/mysql/index.html

Anon

yeah I read that earlier, I just needed an example. Pardon my newbieness...

http://www.mysql.com/doc/D/a/Date_and_time_functions.html

Anon

Not a problem we were all new at one point, that's why I hate saying RTFM.

Anon

As do I... thanks for all your help, I got it working with a bit of tweaking.