Hi,
Im moving data from a OLE DB Source to a Flat File Destination.
I have a DateTime field in my database.
My current query returns:
2007-05-21 00:00:00
How can I make it return:
2007-05-21
Thank you!!
(DT_DBDATE)[YourDateTimeField]|||
I′ve modified the query so it returns only the date.
However, the Flat File Destination always changes it back to a DateTime.
|||
MrHat wrote:
I′ve modified the query so it returns only the date.
However, the Flat File Destination always changes it back to a DateTime.
Yes, you need to define the data type of that column to DT_DBDATE in the flat file connection manager.|||My SQL server destination changes back to DT_DBtimestamp.....in my sql table it has datatype of datetime....but I do not want to display the Time.....just the date....any ideas?|||
JStutz wrote:
My SQL server destination changes back to DT_DBtimestamp.....in my sql table it has datatype of datetime....but I do not want to display the Time.....just the date....any ideas?
Displaying just the time is a simple transact-sql statement using the CONVERT function.
|||Can you use a SQL Command in your source?
If so, use CONVERT(varchar, <dateField>, 112) in your select list
|||
SQL-PRO wrote:
Can you use a SQL Command in your source?
If so, use CONVERT(varchar, <dateField>, 112) in your select list
Still if that's in your source query, you can't store it that way -- not in SQL Server anyway. (Unless you're storing it in a varchar field.)
No comments:
Post a Comment