I have a table that has a field with sample time that is set up as char(24).
I would like to write a SELECT statement converts char(24) to smalldatetime
format.
Table A
Counterdatetime char(24)
Please help me resolve this issue.
Thank You,What is the format of the data in that Counterdatetime column? There are
dozens of possible representations of a smalldatetime that fit in a char(24)
column...
Jacco Schalkwijk
SQL Server MVP
"Joe K." <Joe K.@.discussions.microsoft.com> wrote in message
news:67FB2AE9-F312-4274-B954-265098E50177@.microsoft.com...
> I have a table that has a field with sample time that is set up as
> char(24).
> I would like to write a SELECT statement converts char(24) to
> smalldatetime
> format.
> Table A
> Counterdatetime char(24)
> Please help me resolve this issue.
> Thank You,
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment