Re: Dates: To Slash or to Hyphen. That is the question

2001-08-16 Thread tj marlin
if you don't want the user to input trash, don't give him the opportunity. on your form, put three two character input fields. label the fields month, day and year, or what ever is the most common order that your user will input a date. put '-' or whatever, between the fields - just to make th

Re: Dates: To Slash or to Hyphen. That is the question

2001-08-16 Thread Van
karel pitra wrote: > > hi, > > first - using php wouldn't it be much easier to use an integer to > store datetime in the database? - i think it's faster and it allows you to > manipulate the date much more easily. > > you could just tokenize the date string (using space,'/' and '-' or any ohter

Re: Dates: To Slash or to Hyphen. That is the question

2001-08-16 Thread karel pitra
hi, first - using php wouldn't it be much easier to use an integer to store datetime in the database? - i think it's faster and it allows you to manipulate the date much more easily. you could just tokenize the date string (using space,'/' and '-' or any ohter characters as the separators) - yo

Dates: To Slash or to Hyphen. That is the question

2001-08-15 Thread Van
Greetings: Building a web form. There are 3 datetimes: RequestDate, FulfillDate, and CancelDate. New record populates a web form with the current date/time in -mm-dd hh:mm:ss format. RequestDate is current date, FullFillDate and CancelDate are "-00-00 00:00:00". Updates present them