Menangani tanggal tidak valid

Analisis Deret Waktu di SQL Server

Maham Faisal Khan

Senior Data Science Content Developer

Fungsi konversi tanggal yang tahan error

SELECT
    PARSE('01/08/2019' AS DATE USING 'en-us') AS January8US,
    PARSE('01/08/2019' AS DATE USING 'fr-fr') AS August1FR;
GO

Hasil:

January8US	August1FR
2019-01-08	2019-08-01

SELECT
    PARSE('01/13/2019' AS DATE USING 'en-us') AS January13US,
    PARSE('01/13/2019' AS DATE USING 'fr-fr') AS Smarch1FR;
GO

**Msg 9819, Level 16, State 1, Line 1**

Error converting string value '01/13/2019' into data type date using culture 'fr-fr'.

SELECT
    TRY_PARSE('01/13/2019' AS DATE USING 'en-us') AS January13US,
    TRY_PARSE('01/13/2019' AS DATE USING 'fr-fr') AS Smarch1FR;
GO

January13US	Smarch1FR
2019-01-13	NULL

Menggunakan metode aman tidak lebih mahal daripada metode tidak aman.

Fungsi CAST() dan CONVERT() berjalan dengan kecepatan hampir sama.

Fungsi PARSE() jauh lebih lambat daripada CAST() dan CONVERT().

Ini adalah ukuran per detik, jadi skalanya linear.

Analisis Deret Waktu di SQL Server