I am needing some help with date field issues. I have a date field that I

marieh over 9 years ago

I am needing some help with date field issues.
I have a date field that I am saving to the db as local(now()). Then when it gets pulled from the db it is one day in the past. Then when I display it with local or with out local it is two days in the past. I have even got rid of the local when saving to db and it still does the same thing. Does any one have any suggestions?

Discussion posts and replies are publicly visible

Parents

0 marieh over 9 years ago

I figured out the issue. It is all because we had the db set up for a date field and the local() and gmt() functions only work with a datetime items. So every time I pulled the date from the db it would lose a day and the local() and gmt() functions wouldn't work to convert it to the right date.

Thanks for the help!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 marieh over 9 years ago

I figured out the issue. It is all because we had the db set up for a date field and the local() and gmt() functions only work with a datetime items. So every time I pulled the date from the db it would lose a day and the local() and gmt() functions wouldn't work to convert it to the right date.

Thanks for the help!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data