GoGreen PC TuneUp™
Learn More

Insta-Install™
this is how we code sign our software and ssl encrypt our websites from our affiliate partner SSL.com
MTNCOMP | List | Table

myBlog

myBlog Home

Blog


SQL

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

by Mountain Computers Inc., Publication Date: Monday, July 22, 2019
View Count: 381, 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.