1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

  2. Anuncie Aqui ! Entre em contato fdantas@4each.com.br
Cookies Anuncie aqui Patrocinador Anuncios

[SQL] CONVERT is presenting the wrong year

Discussão em 'Outras Linguagens' iniciado por Stack, Agosto 12, 2021.

  1. Stack

    Stack Membro Participativo

    SQL Server 2014.

    Trying to perform a data conversion, the value being passed '04-SEP-44'

    Since this was the birth year, it needs to 1944, not 2044

    I've tried

    select convert(DATETIME, '04-SEP-44')
    select convert(DATETIME, '04-SEP-44', 1)
    select convert(DATETIME, '04-SEP-44', 13)


    But they are all presenting the year as 2044.

    Are there any quick fixes to this issue?

    Continue reading...
    Stack, Agosto 12, 2021
    #1

Compartilhe esta Página