脱衣舞时间？ [英] Strip Time of a Date?

问题描述

您好！我正在寻找有关如何删除我的日期字符串的时间数据的帮助。每个字段中的信息从另一个类型数据库中提取到访问中。

Hello! I''m looking for help on how to strip time data of my date string. The information in each field is extracted from another type database into access.

例如：


12/31/2007 12：34：56：789

2/2/2007 00： 00:00


我想成为

12/31/2007

2/2/2007

For example:

12/31/2007 12:34:56:789
2/2/2007 00:00:00

I would want to be
12/31/2007
2/2/2007

推荐答案

您是否尝试过将格式设置为日期？

Have you tried just formatting as a date?

展开 | < span class =codeLinkonclick =selectAll（this）;>选择 | Wrap | 行号

您是否尝试过格式化日期？

Have you tried just formatting as a date?

我尝试在查询中使用Format。以及在ACCESS SQL中使用Alter表/列行。当我尝试这些时，一些记录会被删除。即那些像是例如


2/2/2007 12：34：56：789


我在想访问不是没有认识时间格式。我不确定。我正在处理大约12k以上的记录，不幸的是，每个字段中的日期对于进一步的数据库功能非常重要。我很感激反馈意见，我将继续努力。谢谢！

I have tried using Format in a query. As well as using Alter table/Column lines in ACCESS SQL. When I try those, some records get erased. namely those that are like e.g.

2/2/2007 12:34:56:789

I am thinking access doesn''t recognize the time format. I am not for sure. I''m dealing with around 12k plus records, and unfortunately the Dates in each of the fields are important for further database functionality down the road. I appreciate the feedback, and i''ll be still working on it. Thank you!

使用DateValue


所以DateValue（mydatevariable）返回日期/时间值的日期部分

use DateValue

so DateValue(mydatevariable) returns the date portion of a date/time value

这篇关于脱衣舞时间？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！