I support to convert a string with varchar (17) and the data looks like 20070111124536777.
I need convert it to timestamp yyyy-mm-dd hh:nn:ss.
could someone help me please. Please give me the syntax too.
Thank you for your help
Please help StringToTimestamp
Moderators: chulett, rschirm, roy
Code: Select all
StringToTimeStamp(In.Col,'%yyyy%mm%dd%hh%nn%ss')
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: