Jump to content

time


derrick katungi

Recommended Posts

yeah this seems easy enough - this will just be a normal text field which you can use jquery and masked input to create the rule of [0-9]:[0-9] which is cool and if i was you for the database type i would set it as a varchar this would except numbers and characters too.. hope this helpsss :confused:

Link to comment
Share on other sites

Yeah, it appears to be just normal form field processing.

 

You can use the whole mask thing, but I find it annoying when the page dictates what can be entered via javascript. I would just make it so you can accept any time format and then make it the format you want.

 

if i was you for the database type i would set it as a varchar this would except numbers and characters too.

 

I disagree with this. At first it makes it easy as the rules are not so tight as to how it is formatted... but if you need to do any kind of query past SELECT this FROM that you may have trouble.

 

When I started, I would store dates and times in a varchar field and it made it easy, until I needed to select dates and times between 2 points, or dates where it falls on a particular day..

 

Store dates and time as the proper format, it will become easier as time goes.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.