wiz-icon
MyQuestionIcon
MyQuestionIcon
1
You visited us 1 times! Enjoying our articles? Unlock Full Access!
Question

Which of the following is not a valid date type to SQL?

A
CHAR
No worries! We‘ve got your back. Try BYJU‘S free classes today!
B
FLOAT
Right on! Give the BNAT exam to get a 100% scholarship for BYJUS courses
C
CLOB
No worries! We‘ve got your back. Try BYJU‘S free classes today!
D
DATE
No worries! We‘ve got your back. Try BYJU‘S free classes today!
Open in App
Solution

The correct option is B FLOAT

Float is not a valid date type to sql.

Float SQL:-

Decimal has a fixed precision while float has variable precision. EDIT float (53) is a double-precision (32-bit) floating point number in SQL Server. Regular Float is a single-precision floating point number.

Date has no any decimal. So, float is not valid.


flag
Suggest Corrections
thumbs-up
0
Join BYJU'S Learning Program
similar_icon
Related Videos
thumbnail
lock
Approximating Decimals
MATHEMATICS
Watch in App
Join BYJU'S Learning Program
CrossIcon