SQL Data Type Conversions: Your Key to Clean Data & Sharp Queries
May 14, 2025 · This widespread support makes CAST a dependable and portable choice for handling data type conversions directly in your SQL queries. Forget tweaking your queries for …
The CAST operator in PostgreSQL - SQLServerCentral
Oct 15, 2020 · Why do we need to CAST? Let's understand why do we need the casting technique (or briefly the CAST operator) in PostgreSQL with a very simple yet practical example.
SQL CAST Float - SQLServerCentral Forums
Jun 30, 2019 · SELECT price, amount, CAST ( (price + amount) AS FLOAT) as total FROM items; You need to enclose the math operation. Also, as an aside - your training site is probably …
CAST (NULL AS varchar (1)) – SQLServerCentral Forums
Jan 13, 2021 · Home Forums SQL Server 2016 SQL Server 2016 - Development and T-SQL CAST (NULL AS varchar (1)) Post reply
Convert Date to Julian Date – SQLServerCentral Forums
Nov 27, 2017 · SQL Server dates can be cast as decimals, with the integer portion as days since 1900-01-01 00:00. The Julian date is also a decimal value of days since a base date.
CONVERT DATETIME to TIME and remove seconds and milliseconds
Sep 22, 2016 · Home Forums SQL Server 2014 Development - SQL Server 2014 CONVERT DATETIME to TIME and remove seconds and milliseconds Post reply
casting uniqueidentifier to number and back - SQLServerCentral
Jul 24, 2012 · A uniqueidentifier (GUID) contains text, so it's only logical that you cannot convert it directly to an INT. What you can do is create a mapping table. Generate your GUID and insert …
Convert date to MMDDYYYY – SQLServerCentral Forums
Feb 9, 2016 · Convert date to MMDDYYYY Forum – Learn more on SQLServerCentral
DOUBLE precision for calculations / CONVERT TO DOUBLE?
May 19, 2011 · I'm assuming that there is an easy way to cast a variable that is currently stored as a FLOAT as a DOUBLE prior to these calculations for reduced rounding errors, but I can't …
Convert UNIX Timestamps to DATE/TIMEs in SQL Server - Part#1
Mar 10, 2011 · Learn how to easily convert UNIX Timestamps to Date/Times and vice versa in SQL Server and the simple math behind it all. (Jeff Moden)