Response title
This is preview!
DateRangeSlider, format date output
in Using jQuery UI
•
8 years ago
Hi,
How can I format the date output from this slider?
Min and Max values from the slider is used to query reservations in
a mysql database (PHP).
I thought everything was OK until trying the slider on a friends
computer. It seems like the date format follows the locale settings
for the cumputer used.
For instance, on my friends computer the output is formatted:
10/23/2014, 8:00:54 PM
(m/d/Y, g:i:s A)
On my computer the format is:
25.10.2014, 17.30.43
(d.m.Y, H:i:s)
If possible I would prefer to have the output in the format of
mysql datetime:
2014-10-22 14:30:00
(YYYY-MM-DD HH:MM:SS)
If mysql datetime format is impossible I need to at least
"lock the format" to one format no matter the locale of
the computer using the slider if not I cant see how to make the SQL query.
Hopefully someone brighter than me knows how to do this, please
write me a word or two about this.. :)
1
