date - SQL - Datetime stamp in odd format -


i have date timestamp column data in format - yyyymmddhhmmssed e.g. 20140617101703ed

i assume ed designates eastern daylight? regardless, unable perform calculations datediff on columns these. shouldn't able to? if not, how can format column such able perform calculations it? have tried cast, convert, left, can't seem :/

thanks.


Comments

Popular posts from this blog

java - WARN : org.springframework.web.servlet.PageNotFound - No mapping found for HTTP request with URI [/board/] in DispatcherServlet with name 'appServlet' -

html - Outlook 2010 Anchor (url/address/link) -

javascript - Why does running this loop 9 times take 100x longer than running it 8 times? -