if i cross this my project is compleeted

[seshu]

i have a table in which one of the columns work is to save the time that is current time now what should be the data type of that column and after creating the table we can in insert statement if i say the values as now will the current time will be entered
please help me actually this idea is added just now so please help me

[bishwadeep]

Data type:
datetime (if you want date and time both)
time (if you want time only)

time is in the format:
HH:MM:SS

datetime is in th format:
dd:mm:yyyy HH:MM:SS

Insert statement:

Now is not used in mysql, curtime() or curdate() is used

INSERT INTO Yourtable VALUES('curdate().curtime()')

which programming language are you using at front end to insert the time?

if you are using php then:
$current_time = time(); to retrieve the time

if you are using coldfusion then
<cfset time= timeformat(now(),"HH:MM:SS")> to retrieve the time

[seshu]

thank u guys thanx for ur replies but now iam facing one more problem here
in mysql the date format is yyyy-mm-dd but there in my vb.net the date formate is quite reverse now my cmd.executenonquery is not working for this one reason can any one help me out here

[ronverdonk]

Convert the SQL date to the dd-mm-yyyy format using SQL statement

SELECT DATE_FORMAT(column, '%d-%m-%Y')

Ronald :cool: