Welcome Guest, Not a member yet? Register   Sign In
CodeIgniter Forums Using CodeIgniter Best Practices Date Format by input
Date Format by input
  • Offline neuron
    Member
  • ***
  • Posts: 198
    Threads: 39
    Joined: Nov 2016
    Reputation: 8
#3
10-23-2017, 11:25 PM

(10-23-2017, 12:28 PM)Marcolino92 Wrote: Hi, I'm using the "date" fields of a form, so of course the date will be this way: 2017-10-05

I wish the date would turn into the database in a format like this: May 24, 2017

Can someone help me? Thank you

2017-10-05  or yyyy-mm-dd format is easy to manipulate. you can order by date, filter by date in database. 
May 24, 2017 but this type of date is unusefull in database queries. you should store dates in DATETIME mysql format and reformat them after retrieving from database
Reply


Messages In This Thread
Date Format by input - by Marcolino92 - 10-23-2017, 12:28 PM
RE: Date Format by input - by PaulD - 10-23-2017, 01:10 PM
RE: Date Format by input - by neuron - 10-23-2017, 11:25 PM
RE: Date Format by input - by Marcolino92 - 10-26-2017, 10:38 PM



Theme © iAndrew 2016 - Forum software by © MyBB