@sqlite.org
Subject: Re: [sqlite] What is wrong with this SELECT CASE statement?
--- RB Smissaert <[EMAIL PROTECTED]> wrote:
> Trying to update my mmdd integers to months with a SELECT CASE
> statement:
>
> SELECT CASE
> (CAST(DATE_OF_BIRTH / 100 AS INTEGER) - CAST(
--- RB Smissaert <[EMAIL PROTECTED]> wrote:
> Trying to update my mmdd integers to months with a SELECT CASE
> statement:
>
> SELECT CASE
> (CAST(DATE_OF_BIRTH / 100 AS INTEGER) - CAST(DATE_OF_BIRTH / 1 AS
> INTEGER) * 100)
> WHEN 1 THEN UPDATE A2IDC21_J SET DATE_OF_BIRTH = 'January'
>
2 matches
Mail list logo