Add 1 day to timestamp
Posted: Sat Aug 01, 2009 2:51 am
I have a search with in my website which searches the following Company, Type, Date and date1 fields
so you can search a company with the type between 2 dates i.e. 2009-01-01 - 2009-07-05
now my search works however because i'm using a sql timeanddate stamp when the when you search between to dates it only searches from 2009-01-01 00:00:01 to 2009-07-05 00:00:01
so no records show on that date.
i have found my mysql's site that you can add 1 day to it. but i'm not sure how to implement this as I am using dreamweaver.
Let me know and i will post code if you so wish.
Please help.
so you can search a company with the type between 2 dates i.e. 2009-01-01 - 2009-07-05
now my search works however because i'm using a sql timeanddate stamp when the when you search between to dates it only searches from 2009-01-01 00:00:01 to 2009-07-05 00:00:01
so no records show on that date.
i have found my mysql's site that you can add 1 day to it. but i'm not sure how to implement this as I am using dreamweaver.
Let me know and i will post code if you so wish.
Please help.