How format date Carbon:now() in Laravel PHP [duplicate]

Question

I tried

 update(['access' => Carbon::now()->format('Y/m/d H:i:s')]);

it returned Y-m-d H:i:s

Favata

I find this very helpful: carbon.nesbot.com/docs – Surfbird

What did you want it to return? – Nidia

you update this in the database and from the database, you will return only Y-m-d H:i:s – Myrticemyrtie

@RobertColumbia DsRaj I want format 'access' is 'Y/m/d H:i:s', and save it in database. but now it save Y-m-d H:i:s – Favata

The default format in mysql is Y-m-d H:i:s, so it will save and show in the same format. If you still want to store it as Y/m/d H:i:s, then change data type of date field to varchar. – Frog

@LovepreetSingh I have some row 'access' value null. I can't date_format($member['access'], "Y/m/d H:i:s") in file blade Laravel. Error date_format() expects parameter 1 to be DateTimeInterface, string given . How should I do? please help me – Favata

Is the date in the database an actual date type, or is it a string type? – Eaglestone

What's your question after all? Is there anything not working with the given code, or at least not working up to your requirements? – Maricruzmaridel

Reading these comments is like reading 9GAG. It made my day. Thanks, guys! – Marital

Answer 1

now()->format('Y-m-d H:i:s')

You Can Format like above code simply.

Overcharge

Answer 2

<?php
// ...

use Illuminate\Support\Carbon;

//...


$now = Carbon::now()->format('Y-m-d');

Greatniece

Answer 3

The default format in mysql is Y-m-d H:i:s, so it will save and show in the same format. If you still want to store it as Y/m/d H:i:s, then change data type of date field to varchar.

For issue mentioned in comment:

Create date object from string first using date_create and then use date_format to change its format.

$date=date_create($member['access']);
echo date_format($date,"Y/m/d H:i:s");

Frog

It OK. Thank you so much! – Favata

Answer 4

You update this in the database and from the database, you will return only Y-m-d H:i:s(Mysql default format) so

While printing the value of access change the format what you needed.

echo date('Y/m/d H:i:s',strtotime($member['access']));

Myrticemyrtie

Wow, perfect. date_format(date_create($member['access']), "Y/m/d H:i:s") OK too. – Favata