CODEWITHSUNDEEP
laraveleloquent
user11352561
user11352561

Reputation: 2637

Laravel - Extract only time from created_at using DB Raw

I have this Query:

    $qualifiers = DB::table('vw_game_qualifiers as g')
    ->select(
       'g.msisdn', 
       'g.game_code',
       'g.user_channel',
       DB::raw("DATE(created_at) as created_date")
  )

I used

DB::raw("DATE(created_at) as created_date")

to extract only date without time.

How do I extract only time (for example, 11:45:AM) without Date using DB Raw

Upvotes: 0

Views: 3473

Answers (2)

Zain
Zain

Reputation: 482

in views,Using Carbon you can do it,

{{Carbon\Carbon::parse($model->created_at)->format('H:i:s A')}}

Upvotes: 1

user8824269
user8824269

Reputation:

You can try this

DB::raw('TIME(created_at) AS created_date')

Otherwise you can use this 

$model->created_at->format('H:i:s');

Upvotes: 3

Related Questions