Conversion issue

[SqlHunter]

here I want to insert .0000 value (advance_pay-column (type -money) in tbl_ad_book) to the database and it gives me an error saying I need to convert it into datatype

This is not working convert(.0000 as money)

 

[Pattycake245]

Try

cast(.0000 as money)

Tim

 

[dreameR25]

why not just

CAST(0 as money)



Reality of a dreameR.

 

[SQLBill]

SqlHunter,

The two conversion syntax's are:

CAST(value AS datatype)

CONVERT(datatype, value)

One exception to CONVERT. If you are converting from a DATETIME datatype to a string (VARCHAR, CHAR, etc), then it's:

CONVERT(datatype, value, style)

Refer to the BOL, use the Index tab, enter CONVERT.

-SQLBill

BOL=Books OnLine=Microsoft SQL Server's HELP
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine

Posting advice: FAQ481-4875