I want to store a date in phpmyadmin. There are various types of fields related to Date
and time
in phpmyadmin (e.g) Timestamp, DateTime, Date etc...
I am getting date in my form using DateTimePicker
. I have no idea which kind of data type should I choose in my date and time fields in phpmyadmin when I will be saving that prompted date and time from Datetimepicker in database. Is datetimepicker gets saved in phpmyadmin using Date data type or DateTime
data type...?
The DateTimePicker.Value has the type of System.DateTime
The MSDN says:
Remarks
If the Value property has not been changed in code or by the user, it is set to the current date and time (DateTime.Now).