date() convertion

[chitara]

hello Guys,

In my mysql database I store the date value as 

$date =date('y-m-d, h-i-s');

mysql_query( "INSERT INTO tb_user( entery_date, user_name) VALUES('$date', '$sender')" );

So it stores the date value as 2006-11-20 05:17:52

But I want to isolate date & time value like Date: 2006-11-20 & Time: 05:17:52

please tell me how can i do that????

Regards

[Philip]

$date = "Date: " . date('y-m-d'). " & Time: ". date('h:i:s');

[chitara]

hi!

as my mysql table formate is>>

CREATE TABLE `tb_user` (
  `usr_no` int(11) NOT NULL auto_increment,
  `entry_date` datetime default NULL,
  `user_name` varchar(100) default NULL,
  PRIMARY KEY  (`usr_no`),
KEY `user_name` (`user_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=75 ;


so its not working:-(

any suggestion please...

[Philip]

`entry_date` datetime default NULL

If you want it to be in 'Date: 2006-11-20 & Time: 05:17:52' format, with text and other numbers you need to make it a varchar(33) instead of datetime

[printf]

Just do it in the database...

[code]SELECT CONCAT('Date: ', DATE(entry_date), '  & Time: ', TIME(entry_date)) formatted_date FROM tb_user;[/code]

// output... $row['formatted_date']

[code]Date: 2006-11-20  & Time: 05:17:52[/code]

or as two different values...

[code]SELECT CONCAT('Date: ', DATE(entry_date)) AS new_date, CONCAT('Time: ', TIME(entry_date)) new_time FROM tb_user;[/code]

// output... $row['new_date']

[code]Date: 2006-11-20[/code]

// output... $row['new_time']

[code]Time: 05:17:52[/code]

printf

[chitara]

its ok...

but is it possible only to display date: 2006-11-20 from the exisitng format???

please tell me.

[printf]

You don't want => [b]date:[/b]

Then...

[code]SELECT DATE(entry_date) AS new_date, TIME(entry_date) new_time FROM tb_user;[/code]


// output... $row['new_date']

[code]2006-11-20[/code]


// output... $row['new_time']

[code]05:17:52[/code]


printf

[chitara]

thanks a lot:-D

Thats I wanted.

Regards.