Databases
StackOverflow2013
Postsdbo
POHow to make date selection using javascript fromat?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to make date selection using javascript fromat?
    text
    copied!<p><img src="https://i.stack.imgur.com/T8JxY.png" alt="enter image description here">In my PHP project I'm using 3 comboboxes to select Year, month and date. But I can't format that 3 values to save as a date in database in 2013-10-01 type. Given below is my code to select date. <br/></p> <pre><code> &lt;p&gt; &lt;label class="floated" for="dtb_yr"&gt;&lt;b&gt;Date of Birth :&lt;/b&gt;&lt;/label&gt; &lt;select name="dtb_yr"&gt; &lt;option value="2013" /&gt;2013 &lt;option value="2014" /&gt;2014 &lt;option value="2015" /&gt;2015 &lt;option value="2016" /&gt;2016 &lt;option value="2017" /&gt;2017 &lt;option value="2018" /&gt;2018 &lt;option value="2019" /&gt;2019 &lt;option value="2020" /&gt;2020 &lt;option value="2021" /&gt;2021 &lt;option value="2022" /&gt;2022 &lt;/select&gt; &lt;select name="dtb_mon"&gt; &lt;option value="january" /&gt;January &lt;option value="february" /&gt;February &lt;option value="March" /&gt;March &lt;option value="Apirl" /&gt;Apirl &lt;option value="May" /&gt;May &lt;option value="June" /&gt;June &lt;option value="July" /&gt;July &lt;option value="August" /&gt;August &lt;option value="September" /&gt;September &lt;option value="October" /&gt;October &lt;option value="November" /&gt;November &lt;option value="December" /&gt;December &lt;/select&gt; &lt;select name="dtb_day"&gt; &lt;option value="01" /&gt;01 &lt;option value="02" /&gt;02 &lt;option value="03" /&gt;03 &lt;option value="04" /&gt;04 &lt;option value="05" /&gt;05 &lt;option value="06" /&gt;06 &lt;option value="07" /&gt;07 &lt;option value="08" /&gt;08 &lt;option value="09" /&gt;09 &lt;option value="10" /&gt;10 &lt;option value="11" /&gt;11 &lt;option value="12" /&gt;12 &lt;option value="13" /&gt;13 &lt;option value="14" /&gt;14 &lt;option value="15" /&gt;15 &lt;option value="16" /&gt;16 &lt;option value="17" /&gt;17 &lt;option value="18" /&gt;18 &lt;option value="19" /&gt;19 &lt;option value="20" /&gt;20 &lt;option value="21" /&gt;21 &lt;option value="22" /&gt;22 &lt;option value="23" /&gt;23 &lt;option value="24" /&gt;24 &lt;option value="25" /&gt;25 &lt;option value="26" /&gt;26 &lt;option value="27" /&gt;27 &lt;option value="28" /&gt;28 &lt;option value="29" /&gt;29 &lt;option value="30" /&gt;30 &lt;option value="31" /&gt;31 &lt;/select&gt; &lt;br class="clear"/&gt; &lt;/p&gt; </code></pre> <p><br/> Is there any way to select date and save date in more accuracy way, like given below textfeild? <br/></p> <pre><code> &lt;p&gt; &lt;label class="floated" for="model_no"&gt;&lt;b&gt;Model no :&lt;/b&gt;&lt;/label&gt; &lt;input type="text" name="model_no" id="model_no" placeholder="Enter Modle No" /&gt; &lt;br class="clear" /&gt; &lt;/p&gt; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload