time()

[Mutley]

If I'm inserting time into a database, how do I format it?

$time = time();

Is what I have but that is seconds from 1970 or something, I want it to be hours/minutes/seconds in 24 hour style.

[Jessica]

if you want to insert the current time, use NOW();
$sql = "INSERT INTO table VALUES(now())";

otherwise use time() and format it with date(). DATETIME in mysql is YYYY-MM-DD HH:MM:SS ("Y-m-d H:i:s")
Date is same without the time ;)

[curtis_b]

what's the data type in mysql?

check out date()
http://us3.php.net/manual/en/function.date.php

try date(G:i:s)

[marcus]

To use the date function to get hour/min/sec you do:

[code=php:0]
$date = date("h/i/s");
//if you want the 24-hour time syntax
$date = date("H/i/s");
[/code]

[Mutley]

How does displaying different timezones work? GMT for example.