GoGreen PC TuneUp™
Learn More

this is how we code sign our software and ssl encrypt our websites from our affiliate partner SSL.com


myBlog Home

Back to Blog List View Table View MTNCOMP


SQL programming..crash solution.. legacy app data number crunching

by Mountain Computers Inc., Publication Date: Monday, July 22, 2019
View Count: 344, Keywords: SQL, Substring, Convert, Reporting, Date Time, Hashtags: #SQL #Substring #Convert #Reporting #DateTime

SQL programming 101 --- date/time formats and more...
so this is the craziest of all things... parsing date/time fixed formatted columns from static legacy applications that don't follow the rules of date/time formats.
i just had to do some quick programing to get the date formats of a static date/time legacy app to be understood by a new reporting engine.. yuck!! ... 1 hour later ... done!! no stored procedures....
just two real functions that come in handy: substring and convert....
more to come...

if you found this article helpful, consider contributing $10, 20 an Andrew Jackson or so..to the author. more authors coming soon
FYI we use paypal or patreon, patreon has 3x the transaction fees, so we don't, not yet.

© 2021 myBlog™ v1.1 All rights reserved. We count views as reads, so let's not over think it.