topic Re: get date/time type items as string type using 'Data - OLEDB' in Product Forum

get date/time type items as string type using 'Data - OLEDB'

sumire — Wed, 27 Mar 2024 23:58:46 GMT

Hello,

I want to retrieve a DB table using "Data - OLEDB".
In that case, I want to get date/time type items as string type.
I wrote it like this:

cast(startdatesime as Char) as startdatetime

but it gives me an error.
If I just write "startdatetime" and get it as a date/time type, I can get it successfully without error.
Please let me know how to write this.

Thank you for all your help.

Re: get date/time type items as string type using 'Data - OLEDB'

John__Carter — Thu, 28 Mar 2024 09:32:19 GMT

Try String instead of Char

Re: get date/time type items as string type using 'Data - OLEDB'

sumire — Thu, 28 Mar 2024 09:49:04 GMT

Hello @John__Carter ,

Thank you for your reply.
I tried, but got error "Type String is not a defined system type.".

Re: get date/time type items as string type using 'Data - OLEDB'

asilarow — Thu, 28 Mar 2024 11:00:03 GMT

This should give you the desired result:

cast(startdatetime as nvarchar(max)) as startdatetime

Re: get date/time type items as string type using 'Data - OLEDB'

sumire — Wed, 03 Apr 2024 00:53:02 GMT

Hello @asilarow ,

Thank you for your reply.
I took your advice and described it this way:

CONVERT(NVARCHAR(max), startdatetime, 120) as startdatetime

and it worked fine. Thanks.