yesterday and today

最新推荐文章于 2021-12-14 21:03:13 发布
原创 最新推荐文章于 2021-12-14 21:03:13 发布 · 307 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#化工 #电话 #任务 #工作

昨日主要围绕林波和朱经理的到来展开工作，涉及宣讲材料、订发货及设备参数等内容，并陪同晚餐。今日上午开会布置后续任务，包括网站材料收集；下午联系海科化工相关人员，开始学习。

     为什么总是不能静下心来写日志？总会有其他的冒出来？像现在，我又想打个电话了。心情又不能平静地写日志了。

    昨天的工作主要是围绕林波和朱经理的到来展开的，以施工过程为线索整理了些问题。主要包括宣讲材料、订发货、设备参数等方面。晚上陪他们吃的饭。今天上午又开了几次会，布部署了下后边的任务，包括网站方面材料的收集等。

   下午开始联系海科化工方面的人员，还算顺利。开始学习了！

Yesterday,Today and Tomorrow
06-22 140
My last blog article was posted one year ago here,it's coincidence that I logged in my blog today.It is a whole ye...
AtCoDeer and Paint Cans
07-11 360
6471: AtCoDeer and Paint Cans 时间限制:1 Sec内存限制:128 MB 提交:224解决:167 [提交] [状态] [讨论版] [命题人:admin] 题目描述 AtCoDeer the deer recently bought th...
C#: Yesterday, Today, and Tomorrow: An Interview with Anders Hejlsberg
weixin_33711647的博客
11-17 101
C#: Yesterday, Today, and Tomorrow: An Interview with Anders Hejlsberg, Part 1: [url]http://www.ondotnet.com/pub/a/dotnet/2005/10/17/interview-with-anders-hejlsberg.html[/url] C#: Yesterda...
Systemd and sysemctl
哦，原来你也在这里。
12-14 2323
系统结构 Systemd 的设计目标是为系统的启动和管理提供一套完整的解决方案，具体的结构如上图所示。Systtemd不是一个命令，而是一组命令，这组命令涉及系统管理的多个方面。 Systemd的相关命令 systemctl #查看版本 $ sudo systemctl --version # 重启系统 $ sudo systemctl reboot # 关闭系统，切断电源 $ sudo systemctl poweroff # CPU停止工作 $ sudo systemctl halt # 暂停
TODAY IS A GIFT
baci1928的博客
08-26 144
Many people will walk in and out of your life. But only true friends will leave footprints in your heart. To handle yourself, use your head; To handle others, use your heart. Anger is only o...
Python Cookbook 3.1. Calculating Yesterday and Tomorrow
weixin_34221036的博客
09-08 95
Credit: Andrea Cavalcanti Problem 问题 You want to get today's date, then calculate yesterday's or tomorrow's. 你想去获取今天的日期，然后计算昨天或者明天的日期 Solution 解决 Whenever you have to deal with a "chan...
yesterday
weixin_34203426的博客
09-14 129
yesterday is history tommorrow is mistery today is god's gift so we call it present 转载于:https://www.cnblogs.com/superfufu/archive/2009/09/14/1566169.html
Busy yesterday...
michro的博客
11-11 283
Should have a post but missed. Custom should be sticked to and raised, but not as easy as seemed. Learned something but no extension to share. Let's see if something comes out today. Cheers!
Cheeses and bread
simonBlog的博客
03-15 199
Yesterday, I made something special. I first get some bread and cheeses, and then, I put the cheese on the bread, then, I put it in the oven, then, I wait… Grandma used the bread to make a thing, it i...
33. How to get the dates of yesterday, today and tomorrow? (★☆☆) 34. How to get all the dates corresponding to the month of July 2016? (★★☆) 35. How to compute ((A+B)*(-A/2)) in place (without copy)? (★★☆) 36. Extract the integer part of a random array using 5 different methods (★★☆) 37. Create a 5x5 matrix with row values ranging from 0 to 4 (★★☆)
09-16
How to get the dates of yesterday, today and tomorrow? (★☆☆)** #### ✅ 示例代码： ```python import numpy as np today = np.datetime64('today') yesterday = today - np.timedelta64(1, 'D') tomorrow...
python yesterday date
08-10
### 回答1： Here's an example code ...yesterday = today - one_day 最后，我们可以打印出昨天的日期： print("昨天的日期是：", yesterday.strftime("%Y-%m-%d")) 这样，我们就可以在Python中获取昨天的日期了。
yesterday = dt.datetime.now() - dt.timedelta(days=1) yesterday_str = yesterday.strftime("%m月%d日") month_start = yesterday.replace(day=1).strftime("%m月%d日") # 计算上月同天 last_month_same_day = yesterday - dt.timedelta(days=yesterday.day) last_month_start = last_month_same_day.replace(day=1).strftime("%m月%d日") last_month_same_day_str = last_month_same_day.strftime("%m月%d日") 匹配SQL意图BETWEEN ADD_MONTHS(TRUNC(SYSDATE - 1, ‘month’), -1) AND ADD_MONTHS(TRUNC(SYSDATE - 1), -1) 修改代码
11-04
yesterday = today - timedelta(days=1) # → 2025-11-02 # 左边界：上个月第一天（SQL左边界） left_bound = yesterday.replace(day=1) - timedelta(days=1) # 先获取上月最后一天 left_bound = left_bound....
function return_qty($db,$status){ $db = MySQLDB::getInstance(); $sql="select SUM(CASE WHEN DATE(create_time) = CURDATE() THEN 1 ELSE 0 END) AS today_cnt from return_shipping_info where status='$status'"; $row = $db->fetchRow($sql); $num = $row['today_cnt']; return $num; } function return_qty_1($db,$status){ $db = MySQLDB::getInstance(); $sql="select SUM(CASE WHEN DATE(create_time) = CURDATE() - INTERVAL 1 DAY THEN 1 ELSE 0 END) AS yesterday_cnt from return_shipping_info where status='$status'"; $row = $db->fetchRow($sql); $num = $row['yesterday_cnt']; return $num; } function return_qty_2($db,$status){ $db = MySQLDB::getInstance(); $sql="SELECT COUNT(*) AS count FROM return_shipping_info WHERE status = '$status' and create_time < CURDATE() - INTERVAL 2 DAY AND create_time >= CURDATE() - INTERVAL 1 WEEK"; $row = $db->fetchRow($sql); $num = $row['count']; return $num; } function return_qty_3($db,$status){ $db = MySQLDB::getInstance(); $sql="SELECT COUNT(*) AS count FROM return_shipping_info WHERE status = '$status' AND (create_time < CURDATE() - INTERVAL 1 WEEK) AND (create_time >= CURDATE() - INTERVAL 1 MONTH)"; $row = $db->fetchRow($sql); $num = $row['count']; return $num; }这样查询OK吗？当天数据，昨天数据，本周数据，本月数据
最新发布
12-02
$sql="SELECT COUNT(*) AS count FROM return_shipping_info WHERE status = '$status' and create_time () - INTERVAL 2 DAY AND create_time >= CURDATE() - INTERVAL 1 WEEK"; $row = $db->fetchRow($sql); $...
将1 也跟3一样 时间判断 from datetime import datetime, timedelta, timezone def get_bet_details(mysql, agent_id, user_id, draw_period=None, leix=None): """ 根据agent_id, user_id 和 draw_period查询用户的投注记录 :param mysql: 数据库连接对象 :param agent_id: 代理ID :param user_id: 用户ID :param draw_period: 抽奖周期（可选） :param leix: 查询类型（1: 当前期数, 3: 今日数据（支持跨天+时区）） :return: 查询结果列表 """ try: cursor = mysql.connection.cursor(MySQLdb.cursors.DictCursor) if leix == '3': # 设置时区为 UTC+8（你可以根据需要修改） tz = timezone(timedelta(hours=8)) now = datetime.now(tz) # 带时区的当前时间 # 构造今天 18:57 的时间点 today_18_57 = now.replace(hour=18, minute=57, second=0, microsecond=0) if now > today_18_57: # 查询今天的 18:57 之后的数据 start_time = today_18_57 end_time = now else: # 查询昨天 19:30 到今天 18:57 的数据 yesterday_19_30 = (now - timedelta(days=1)).replace( hour=19, minute=30, second=0, microsecond=0 ) start_time = yesterday_19_30 end_time = today_18_57 # 转换为字符串用于 SQL 查询（格式：YYYY-MM-DD HH:MM:SS） start_time_str = start_time.strftime('%Y-%m-%d %H:%M:%S') end_time_str = end_time.strftime('%Y-%m-%d %H:%M:%S') # 构建 SQL 查询语句 query = f""" SELECT SUM(amount) AS total_amount, SUM(win_amount) AS total_win_amount, SUM(CASE WHEN win_amount > 0 THEN win_amount - amount ELSE win_amount END) AS net_win_amount, COUNT(DISTINCT draw_period) AS periods_count FROM bets WHERE agent_id = %s AND user_id = %s AND bet_time BETWEEN '{start_time_str}' AND '{end_time_str}' """ cursor.execute(query, (agent_id, user_id)) elif leix == '1': query = """SELECT bets.*, users.balance FROM users LEFT JOIN bets ON bets.user_id = users.id AND bets.agent_id = %s AND bets.draw_period = %s WHERE users.id = %s """ cursor.execute(query, (agent_id, draw_period, user_id)) elif leix == '4': query = """ SELECT * FROM bets WHERE agent_id = %s AND user_id = %s AND DATE(bet_time) = CURDATE() """ cursor.execute(query, (agent_id, user_id)) else: raise ValueError("leix 参数必须是 '1', '3' 或 '4'") bet_details = cursor.fetchall() cursor.close() return bet_details except Exception as e: return {'error': f'查询失败: {str(e)}'}
07-09
AND bet_time BETWEEN '{start_time_str}' AND '{end_time_str}' """ cursor.execute(query, (agent_id, user_id)) elif leix == '1': start_time_str, end_time_str = get_time_range() query = """ ...
学来的三线表的画法
lc_dsj的专栏
05-06 1714
先制作一个普通表格,然后word里面,表格/自动套用格式/古典型1,然后下面复选框只选中第一个,所做的表就是三线表。如图所示利用Word的自动套用表格样式，然后稍做修改
外场巡视录01
lc_dsj的专栏
03-07 882
天气真的变暖了，风吹在身上感觉非常舒服。这个季节去外面转转是件让人高兴的事，可是因为工作要出去，还要陪着甲方和监理，让人感觉略有不适！究其原因，不深究，今天就外场进度问题，从技术的角度剖析下。          1，设备已经完成安装，但是无处引电。其中两个点位于一个十字路口的两侧，从附近交通岗引电，但后来线被扯了，甲方的人去沟通，同意把电接上，但是推辞说交通岗本身没有电。          2
女友在另一个城市找到了工作
lc_dsj的专栏
03-22 837
一场大病、一段时间的轰轰烈烈的心理革命研究生的女友在另一个城市找到了工作从知道到现在过去24小时了我心一直持续亢奋在这个不平静的心态下混乱的思维指挥着零星无序的动作短路的神经产生了无数强烈、杂乱的火花大脑皮层的兴奋此起彼伏乱麻似的网状结构彼此之间纠结的更紧过去、现在和将来昨天、今天和明天 不知是无标准的对错导致了现在的无所谓还是无所谓
增长有点快的外债
lc_dsj的专栏
12-21 835
       18号下午去北京，21号凌晨2点回到东营。期间花了2.5k，外债有所增长，又有3K。       应该有所改变了。       沉着冷静、整合资源。       今天本来是要整理网站资料的，又打扫了一个小时的卫生。
掷去欺辱 自取其辱 智取其乳
lc_dsj的专栏
11-26 819
  天行健、君子当自强不息！
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值