Date/time problem

[catalinus]

I have the following situation: each time i insert a row into a table, i want the date of the operation to be inserted in a separated field(called process_date). I have set the process_date field to be a timestamp type, and its defalut value to be now(), but the date inserted into it is like 00000000000000. How can I solve this problem? Thanks

[badman]

every time you insert something, your query shud have now() for the timestamp field.
example

insert into mytable values("","",now());

i always use it in this way and havent had any problems!

[crislewis]

More simply:

Set the database field in the table definition to be NOT NULL - do not have a default value.

On INSERT of UPDATE set the field value to be NULL.

The database serve will automatiically insert the current timestamp into the field, i.e. you don't need the Now().

Cheers,

cris

[catalinus]

I have tried this, rj, but I get the date under a format like this: 20010806231545. I need this date to be printed with separators, 2001-08-06 23:15:45 instead of 20010806231545. Could you help me with an answer here?

[crislewis]

If you want this format in the database then you will need to use a char field and explicitly set the value on update or insert. However, if you want to use a timestamp then all you need is a function to 'decode' it for you into the format you want. How about:

Function sql_date_and_time($sql_date) {

$read_date = substr($sql_date,6,2)."/";
$read_date .= substr($sql_date,4,2)."/";
$read_date .= substr($sql_date,0,4)." at ";
$read_date .= substr($sql_date,8,2).":";
$read_date .= substr($sql_date,10,2).":";
$read_date .= substr($sql_date,12,2);

return $read_date;

Cheers,

Cris