Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Literal and Null Value Formats

Literal and Null Value Formats

Table A-9. Literal and Null Value Formats
Field TypeData TypeLiteral ValueNULL Formula
Checkbox
Phone
Picklist
Text
Character‘Unspecified’‘’ (two single quote marks)
Currency
Integer
Number
Percent
Numeric0CASE WHEN 0 = 1 THEN 0 ELSE NULL END
DateDateDATE ‘1000-01-01’CASE WHEN DATE ‘1000-01-01’ = DATE ‘9999-09-09’ THEN DATE ‘1000-01-01’ ELSE NULL END
Date/TimeTimestampTIMESTAMP ‘1000-01-01 00:00:00’CASE WHEN TIMESTAMP ‘1000-01-01 00:00:00’ = TIMESTAMP ‘9999-09-09 00:00:00’ THEN TIMESTAMP ‘1000-01-01 00:00:00’ ELSE NULL END



  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint