Getting error while fetching data from db in Laravel

Question

I am trying to get data that match with my giving time, i pass time as a string for now but it gives error,

here is my code

$final_trade = FinalTrade::where('user_id', $user_id)
        ->where(Carbon::parse('created_at')->format('h:i:s'), '9.30.00')
        ->first();

here is the error,

DateTime::__construct(): Failed to parse time string (created_at) at position 0 (c): The timezone could not be found in the database

arun · Accepted Answer · 2018-06-02 10:18:49Z

1

You can use whereTime directly without parsing,

$final_trade = FinalTrade::where('user_id', $user_id)
               ->whereTime('created_at', '=', '9:30:00')
                ->first();

answered Jun 2, 2018 at 10:18

arun

4,8135 gold badges24 silver badges43 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Muhammad Arslan Over a year ago

this works, what if i need to compere time and add hours in it ?

Muhammad Arslan Over a year ago

actually i need to get time between range, i just have start time, so i need to add hour in it like start date and end date

arun Over a year ago

@MuhammadArslan, for that you may use accessor, getCreatedAtAttribute and u can return whatever you want.

code_ablaze · Accepted Answer · 2018-06-02 10:12:35Z

0

You need to pass date in the parse not string https://carbon.nesbot.com/docs/ Read the docs

answered Jun 2, 2018 at 10:12

code_ablaze

4624 silver badges16 bronze badges

2 Comments

Muhammad Arslan Over a year ago

what do you means ?

code_ablaze Over a year ago

First off there is error in your syntax where expects first parameter to be column's name and you should pass date format like Carbon::parse('2018-02-18 10:00:01') like so

EchoAro · Accepted Answer · 2018-06-02 10:12:41Z

0

The first field in the where method must be the name of the table field

$final_trade = FinalTrade::where('user_id', $user_id)
        ->where('created_at', '9.30.00')
        ->first();

please read this laravel query builder

answered Jun 2, 2018 at 10:12

EchoAro

8381 gold badge8 silver badges27 bronze badges

3 Comments

Muhammad Arslan Over a year ago

this always return null

Muhammad Arslan Over a year ago

this is the actual date i have, 2018-05-25 09:30:00

EchoAro Over a year ago

if you want to do what you need during the search, or save the time in the created_at table, or use CARBON to format the time to the date and time. although it would be more correct if the table saved the time and not the datetime

Collectives™ on Stack Overflow

Getting error while fetching data from db in Laravel

3 Answers 3

3 Comments

2 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related