如何从SQLSSIS中删除日期时间字符串的日期？-HowdoIstripthedateoffofadatetimestringinSQLSSIS?

I would just do a cast to DT_DBTIME type (using Derived Column transform, or Convert type transform). DT_DBTIME contains just (hours, minutes, seconds) part of the date/time, so you'll get rid of the date part.

我只是对DT_DBTIME类型进行强制转换(使用派生列转换或转换类型转换)。 DT_DBTIME只包含(小时,分钟,秒)日期/时间的一部分,因此您将摆脱日期部分。

If you need to do this in a variable expression Michael's solution won't work, but you can use the following expression:

如果您需要在变量表达式中执行此操作,Michael的解决方案将不起作用,但您可以使用以下表达式:

(DT_DATE)(DT_DBDATE)GETDATE()

(DT_DBDATE) converts the current date and time to a date only. But the new datatype is not compatiple with SSIS's datetime. Therefore you'll have to use (DT_DATE) for converting to a compatible type.

(DT_DBDATE)仅将当前日期和时间转换为日期。但是新的数据类型与SSIS的日期时间不兼容。因此,您必须使用(DT_DATE)转换为兼容类型。

Courtesy of this solution belongs to Russel Loski who has posted it in his blog: http://www.bidn.com/blogs/RussLoski/ssas/1458/converting-datetime-to-date-in-ssis

感谢这个解决方案属于Russel Loski,他已将其发布在他的博客中:http://www.bidn.com/blogs/RussLoski/ssas/1458/converting-datetime-to-date-in-ssis

Actually if you reverse the first 2 expressions like this: (DT_DBDATE)(DT_DATE)GETDATE() instead of (DT_DATE)(DT_DBDATE)GETDATE(), then you will TRUNCATE the time off the date field.

实际上,如果您反转前两个这样的表达式:(DT_DBDATE)(DT_DATE)GETDATE()而不是(DT_DATE)(DT_DBDATE)GETDATE(),那么您将截断日期字段的时间。

If the DT_DATE expression is before the DT_DBDATE expression, you will still have the time portion in your output, but it will be reset to all zeroes.

如果DT_DATE表达式在DT_DBDATE表达式之前,您仍将在输出中包含时间部分,但它将重置为全零。

Ran into this with writing a report for a scheduling app, needed the time that was stored as part of a datetime data type. I formated the datetime as 0 which gives you this mon dd yyyy hh:miAM (or PM), and just did a substring of that which returned the time only in an AM/PM format.

通过为调度应用程序编写报告,需要将时间存储为日期时间数据类型的一部分。我将datetime格式化为0,这给了你这个mon dd yyyy hh:miAM(或PM),并且只做了一个子串,只返回AM / PM格式的时间。

Example below.

DECLARE @S DATETIME = GETDATE()

SELECT SUBSTRING(CONVERT(NVARCHAR(30), @S , 0) , 13 , 10) AS ApptTime
    , CONVERT(NVARCHAR(30), @S , 0) AS ApptDate

I personally use a series of functions for this. E.g.:

我个人为此使用了一系列功能。例如。:

ALTER FUNCTION [dbo].[TIMEVALUE]
(
 @Datetime datetime
)
RETURNS datetime
AS
BEGIN
    RETURN (@Datetime - CAST(ROUND(CAST(@Datetime AS float), 0, 1) AS datetime))
END

I'd love to claim all the credit but it should really go to this guy.

我很想获得所有的功劳,但它真的应该归功于这个人。