te')); return $arr; } /* 遍历用户所有主题 * @param $uid 用户ID * @param int $page 页数 * @param int $pagesize 每页记录条数 * @param bool $desc 排序方式 TRUE降序 FALSE升序 * @param string $key 返回的数组用那一列的值作为 key * @param array $col 查询哪些列 */ function thread_tid_find_by_uid($uid, $page = 1, $pagesize = 1000, $desc = TRUE, $key = 'tid', $col = array()) { if (empty($uid)) return array(); $orderby = TRUE == $desc ? -1 : 1; $arr = thread_tid__find($cond = array('uid' => $uid), array('tid' => $orderby), $page, $pagesize, $key, $col); return $arr; } // 遍历栏目下tid 支持数组 $fid = array(1,2,3) function thread_tid_find_by_fid($fid, $page = 1, $pagesize = 1000, $desc = TRUE) { if (empty($fid)) return array(); $orderby = TRUE == $desc ? -1 : 1; $arr = thread_tid__find($cond = array('fid' => $fid), array('tid' => $orderby), $page, $pagesize, 'tid', array('tid', 'verify_date')); return $arr; } function thread_tid_delete($tid) { if (empty($tid)) return FALSE; $r = thread_tid__delete(array('tid' => $tid)); return $r; } function thread_tid_count() { $n = thread_tid__count(); return $n; } // 统计用户主题数 大数量下严谨使用非主键统计 function thread_uid_count($uid) { $n = thread_tid__count(array('uid' => $uid)); return $n; } // 统计栏目主题数 大数量下严谨使用非主键统计 function thread_fid_count($fid) { $n = thread_tid__count(array('fid' => $fid)); return $n; } ?>javascript - Setting ISO date time to zero - Stack Overflow

科技改变生活-雨落星辰 - 所有的伟大,都源于一个勇敢的开始

    最新消息：雨落星辰是一个专注网站SEO优化、网站SEO诊断、搜索引擎研究、网络营销推广、网站策划运营及站长类的自媒体原创博客
    你的位置： 首页>programmer>javascript - Setting ISO date time to zero - Stack Overflow

    javascript - Setting ISO date time to zero - Stack Overflow

    programmeradmin3浏览0评论

    I'm trying to pare a Date ming from a Mongo query that has a date in ISO format. The date is the following:

    2018-01-20T00:00:00.000Z

    I want to pare today's date with this, so my approach was to create a new date and set its time to zero like this:

    var today = new Date();
today.setHours(0,0,0,0); //Sat Jan 20 2018 00:00:00 GMT-0800 (PST)

    With this, it seems like the time is set to zero. The problem es when I convert it to ISO string for parison:

    console.log(today.toISOString()); //2018-01-20T08:00:00.000Z

    As you can see, it sets everything to zero but hour, that remains at 08. I can't get to set this hour to zero.

    I'm trying to pare a Date ming from a Mongo query that has a date in ISO format. The date is the following:

    2018-01-20T00:00:00.000Z

    I want to pare today's date with this, so my approach was to create a new date and set its time to zero like this:

    var today = new Date();
today.setHours(0,0,0,0); //Sat Jan 20 2018 00:00:00 GMT-0800 (PST)

    With this, it seems like the time is set to zero. The problem es when I convert it to ISO string for parison:

    console.log(today.toISOString()); //2018-01-20T08:00:00.000Z

    As you can see, it sets everything to zero but hour, that remains at 08. I can't get to set this hour to zero.

    • javascript
    • mongodb
    • date
    Share Improve this question asked Jan 21, 2018 at 1:48 oneberenjenaoneberenjena 1652 silver badges8 bronze badges 2
    • theres a bunch of setUTC* functions... – Daniel A. White Commented Jan 21, 2018 at 1:55
    • @oneberenjena check the answer posted. hope it helps. – Gopalkrishna Narayan Prabhu Commented Jan 21, 2018 at 2:03
    Add a ment  | 

    2 Answers 2

    Reset to default 14 

    var today = new Date();
today.setUTCHours(0,0,0,0);

document.getElementById('val').innerHTML = today.toISOString();
    <label>Date: (ISO String)</label>
<div id="val">
<div>

    today.setUTCHours(0,0,0,0);

    This will set the UTC hours giving you the desired output.

    The above ment is the correct answer. My task was to find all the bookings in the present date, past date, and future date. I had to query the MongoDB database. The above ISO String method helped me to solve my problem. Thank You very much.

     const { past, present, future } = req.query;

  let today = new Date();
  today.setUTCHours(0, 0, 0, 0);
  today.toISOString();

  let bookings;

  if (past === 'past') {
    bookings = await Booking.find({
      booking_user: req.user.userId,
      booking_checkin: { $lt: today },
    }).sort('-booking_status : cancelled');
  } else if (present === 'present') {
    bookings = await Booking.find({
      booking_user: req.user.userId,
      booking_checkin: { $eq: today },
    }).sort('-booking_status : cancelled');
  } else if (future === 'future') {
    bookings = await Booking.find({
      booking_user: req.user.userId,
      booking_checkin: { $gt: today },
    }).sort('-booking_status : cancelled');
  } else {
    bookings = await Booking.find({
      booking_user: req.user.userId,
    }).sort('-booking_status : cancelled');
  }

  res.status(StatusCodes.OK).json({ count: bookings.length, bookings });

    与本文相关的文章

    发布评论

    评论列表(0)

    1. 暂无评论