ICES Marine Data
DATSU
 
DATSU > List of operations > Specification of the format > Details of the check
 

   
Details of a check:
   
Record: EH
Check Description: The combination of Year, Month, Day, Hour and Minute does not give a valid datetime
Error type: error

RecordSQL ExpressionSQL Type
EHFROM REH where TRY_CAST(CAST([year] AS varchar) + '-' + CAST([Month] AS varchar) + '-' + CAST([Day] AS varchar) + ' ' + cast(replace(Hour_txt,'-9','00') as varchar) + ':' + cast(replace(Minute_txt,'-9','00') as varchar) AS datetime) is nullFree SQL

International Council for the Exploration of the Sea (ICES) · Conseil International pour l'Exploration de la Mer (CIEM)
ICES Secretariat · H. C. Andersens Boulevard 44-46, DK 1553, Copenhagen Denmark · Tel: +45 3338 6700 · Fax: +45 3393 4215 · info@ices.dk
Disclaimer © ICES - All Rights Reserved