mysql取范围纪录,mysql-仅获取今天创建的记录

使用Mysql默认的29953410565705574574函数来获取当天的所有记录。

$records = DB::table('users')->select(DB::raw('*'))

->whereRaw('Date(created_at) = CURDATE()')->get();

dd($record);

注意

2995341056556570557440与2995341056570557457441之间的区别只是时间。

例如

通过DB打印的日期看起来像：

DB

而在DB中：

DB

要获取今天使用2995341056570557457440创建的唯一记录，可以提取为：

DB

而使用DB：

DB

更新

从laravel 5.3开始，我们有默认的where子句DB

$users = User::whereDate('created_at', DB::raw('CURDATE()'))->get();

或与DB门面

$users = DB::table('users')->whereDate('created_at', DB::raw('CURDATE()'))->get();

上面列出的where子句的用法

$users = User::whereMonth('created_at', date('m'))->get();

//or you could also just use $carbon = \Carbon\Carbon::now(); $carbon->month;

//select * from `users` where month(`created_at`) = "04"

$users = User::whereDay('created_at', date('d'))->get();

//or you could also just use $carbon = \Carbon\Carbon::now(); $carbon->day;

//select * from `users` where day(`created_at`) = "03"

$users = User::whereYear('created_at', date('Y'))->get();

//or you could also just use $carbon = \Carbon\Carbon::now(); $carbon->year;

//select * from `users` where year(`created_at`) = "2017"

查询生成器文档