How do I concatenate strings with SQL?

  Much unlike their string-to-date conversion differences, SQL Server and MySQL use a function for concatenating strings - concat() - which is identical in syntax and performance on both platforms.   As you'll see above, the odd ones out this time round are PostgreSQL and Vertica. Although concat() is also available in Vertica, it can only join … Continue reading How do I concatenate strings with SQL?

How do I convert string to a date with SQL?

Hit a couple of error messages when trying to convert a string to a date? And that's totally not surprising! As you'll see below the text-to-date conversion functions within the different database environments seldom have identical syntax Why would you want to convert a string to a date? Well, it could be pretty useful if … Continue reading How do I convert string to a date with SQL?