Welcome to Sign in | Help
in Search

Browse by Tags

All Tags » cast
  • datetime SQL vs Excel (why the difference?)

    select CAST(FLOOR(CAST(cast('2010-02-01' as datetime) AS FLOAT)) AS int) = 40208 40208 in Excel = 01/30/2010
    Posted to Question of the Day (Forum) by darius2 on March 14, 2010
  • Functia CAST

    Salut, va rog imi poate spune cineva cum as putea prinde o eroare de conversie intoarsa de functia CAST intr-o functie fara sa folosesc TRY CATCH. Incerc sa fie compatibila si cu SQL Server 2000 si cu 2005. Lucrez pe un 2005. Uitati ce am incercat :) DECLARE @x AS VARCHAR(50) ....  SELECT @y = CAST(@x AS BIGINT) IF @@ERROR  ...
    Posted to T-SQL (Forum) by cretzu on November 27, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems