Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › How do I let the user fill in a time with only hour and minutes?

How do I let the user fill in a time with only hour and minutes?

Thread began 1/03/2020 9:21 am by Jonas | Last modified 1/03/2020 9:36 am by Ray Borduin | 218 views | 1 replies |

1/03/2020 9:21 am | #1 Jonas

How do I let the user fill in a time with only hour and minutes?

I want admin to be able to fill in a time in a form. The user should only need to fill in hours and minutes. In DataAssist there is the "Time" type with the possibility to select the format "HH:mm". But how is this stored in the database? What type should the database field have? It doesn't seem to work with "TIME". I get an error message: "There is an error in your SQL syntax." it says.

1/03/2020 9:36 am | #2 Ray BorduinWebAssist

I'd just use a varchar in the database to save the time.

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.