Level 88
If you do it like this it should work fine
public function create(Request $request)
{
$project = new Project();
$project->date = Carbon::parse('15/02/1394');
$project->save();
}
May 6, 2015
9
Level 2
save Solar date in database
I have a solar date picker and it give me a date like this format : 15/02/1394
I want to save this date in my database...
I have a date field in my database. when I try to save date , it saved like this :0000-00-00
how can save this date?
and:
what is true?
1.save date with this format 15/02/1394
2.convert it to for example 2015-5-5
Level 53
Like @bobbybouwmann , but use createFromFormat('d/m/Y', $value).
parse treats such date as m/d/Y, it will throw error for 12+ first segment, and obviously will hold different date to what you expect.
Level 88
Fair enough, I was just pushing him in the right direction ;)
Level 13
Is the year 1394?? This will cause problems using UNIX date on the database side.
Level 2
@jimmck the solar date format is like this 15/02/1394 and i must use this format.
what is your idea about solving this problem?
Level 88
Is the date really 1394?
Level 2
@bobbybouwmann , yes , I am Iranian. we work with solar date. for example today is 20/02/1394.
and now it is my problem that can I save my date with this format or must convert?
Level 88
Mmh no idea on how to use those kind of dates, you might be able to find a package that can convert the current time into your specific time?
Level 13
Interesting problem. Your going to need to convert back and forth for the database work. So for MySQL I found this.
https://github.com/zoghal/Presian-Date-for-MySQL
On the code/app side I found this:
http://www.codeproject.com/Articles/28380/Persian-Calendar-in-PHP
I have done lots of work with reference data in financial applications and never came across this. I am going to explore this more. Great problem!
Please or to participate in this conversation.