Getting day, month and year apart from Db |
If you are obtaining your date from a database query, why not split your date with the query. MySQL has date functions for this case.
Start here https://www.w3resource.com/mysql/date-an...nction.php E.g. SELECT YEAR( '2009-05-19' ) AS yr -> will give 'yr' as 2009. Replace the date with the appropriate field. |
Messages In This Thread |
Getting day, month and year apart from Db - by jordyd - 03-09-2018, 03:45 PM
RE: Getting day, month and year apart from Db - by enelson - 03-12-2018, 12:20 PM
RE: Getting day, month and year apart from Db - by ivantcholakov - 03-12-2018, 01:01 PM
RE: Getting day, month and year apart from Db - by ivantcholakov - 03-12-2018, 01:20 PM
RE: Getting day, month and year apart from Db - by Mr Lister - 03-18-2018, 02:19 AM
RE: Getting day, month and year apart from Db - by jordyd - 03-19-2018, 01:23 AM
RE: Getting day, month and year apart from Db - by pooja7r - 03-23-2018, 06:19 AM
|