Hitachi

Hitachi Advanced Database Messages


KFAA31212-E

The datetime format specified in the scalar function is not compatible with the "TIME" data. (argument number = aaa, function name = "bb....bb", query number = cc....cc) (M+J+O)

The datetime format specified in the scalar function bb....bb is not compatible with the time data. <SQLSTATE: 42787>

aaa:

Argument number

bb....bb:

Scalar function name

cc....cc: Position number of the query that specified bb....bb

For details about query position numbers, see 1.5 Query position numbers.

S:

Ignores this SQL statement. Alternatively, the system invalidates this transaction.

Action:

Correct the datetime format. Specify a datetime format (that specifies hours, minutes, or seconds) that is compatible with the time data.