Welcome Guest, Not a member yet? Register   Sign In
how to insert a current date into a database
#4

[eluser]n0xie[/eluser]
[quote author="sramkrish" date="1253098235"]hi . i want to insert the current date and time into the database . In database i was created a table named userdtails in that i created one field named ts_created of type datetime . In this field i have to insert date and time for the detail about the user .
date and time in format of yyyy/mm/dd hrs/minutes/seconds
please anyone help me[/quote]
Most databases have an option to fill the current timestamp in a field when a new record is inserted. Presuming you use MySQL take a look here.


Messages In This Thread
how to insert a current date into a database - by El Forum - 09-15-2009, 11:50 PM
how to insert a current date into a database - by El Forum - 09-16-2009, 12:22 AM
how to insert a current date into a database - by El Forum - 09-16-2009, 12:39 AM
how to insert a current date into a database - by El Forum - 09-16-2009, 02:08 AM
how to insert a current date into a database - by El Forum - 09-16-2009, 03:55 AM
how to insert a current date into a database - by El Forum - 09-16-2009, 08:50 AM
how to insert a current date into a database - by El Forum - 09-16-2009, 10:43 AM



Theme © iAndrew 2016 - Forum software by © MyBB