All Questions
2 questions
0
votes
1
answer
223
views
Formatting 11/16/2002 12:00:00 PM to date time stamp in MySQL
How do I change this format "11/16/2002 12:00:00 PM" to something that MySQL will understand without using PHP?
I've tried SELECT CONVERT('11/03/2002 02:45:33 PM', DATETIME) AS datetime; and I ...
- 2,237
0
votes
1
answer
253
views
how to get row when change in column data
I have following table
Id | Status | date
-------------------
1 | Onsite |2007
2 | Onsite |2008
3 | Onsite |2009
4 | Abroad |2010
5 | Abroad |2011
6 | Onsite |2012
7 | Abroad |2013
8 ...
- 836