{"id":46,"date":"2021-03-19T12:50:17","date_gmt":"2021-03-19T12:50:17","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/?page_id=46"},"modified":"2021-11-17T15:58:43","modified_gmt":"2021-11-17T15:58:43","slug":"data-types","status":"publish","type":"page","link":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/reference\/data-types\/","title":{"rendered":"Data Types"},"content":{"rendered":"

National 5 and Higher<\/h1>\n

Text<\/h2>\n

Text values are enclosed in apostrophes (or quotation marks):<\/p>\n

\r\nSELECT * FROM orders\r\nWHERE productname LIKE 'Marzipan'\r\n<\/pre>\n
Number<\/h2>\n
\r\nSELECT * FROM orders\r\nWHERE price > 14.95\r\n<\/pre>\n
Date<\/h2>\n
SQLite stores dates as text fields. They must be stored as ‘yyyy-mm-dd’ eg ‘2021-03-05’<\/p>\n
\r\nSELECT * FROM orders\r\nWHERE date <= '2020-03-28'\r\n<\/pre>\n
Time<\/h2>\n
SQLite stores times as text fields. They must be stored as ‘hh:mm:ss’<\/p>\n
\r\nSELECT * FROM orders\r\nWHERE time BETWEEN '09:00:00' AND '09:59:59'\r\n<\/pre>\n
Boolean<\/h2>\n
SQLite stores Boolean values as numbers – 1 for True and 0 for False<\/p>\n
\r\nSELECT * FROM orders\r\nWHERE delivered = 1\r\n<\/pre>\n
Advanced Higher<\/h1>\n
In Advanced Higher you must use standard SQL types:<\/p>\n\n\n\n\n\n\n\n\n
Data Type<\/strong><\/td>\nSample<\/strong><\/td>\nSQL<\/strong>
\nimplementation<\/strong><\/td>\n		Comment<\/strong><\/td>\n<\/tr>\n
integer<\/td>\n32, -46<\/td>\n\n
int<\/pre>\n<\/td>\n
using a size parameter is optional; it is used to restrict the maximum display width<\/td>\n<\/tr>\n
float<\/td>\n3.14<\/td>\n\n
float(size,d)<\/pre>\n<\/td>\n
the size parameter specifies the total number of digits displayed, while d specifies the number of digits after the decimal point<\/td>\n<\/tr>\n
varchar<\/td>\nABC123D<\/td>\n\n
varchar(size)<\/pre>\n<\/td>\n
the size parameter is mandatory, to restrict number of characters possible between 0 and 65535<\/td>\n<\/tr>\n
date<\/td>\n2019-05-23<\/td>\n\n
date<\/pre>\n<\/td>\n
format is YYYY-MM-DD<\/td>\n<\/tr>\n
time<\/td>\n09:12:47<\/td>\n\n
time<\/pre>\n<\/td>\n
format is YYYY-MM-DD<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
Primary and Keys<\/<\/h2>\n","protected":false},"excerpt":{"rendered":"
National 5 and Higher Text Text values are enclosed in apostrophes (or quotation marks): SELECT * FROM orders WHERE productname LIKE ‘Marzipan’ Number SELECT * FROM orders WHERE price > 14.95 Date SQLite stores dates as text fields. They must be stored as ‘yyyy-mm-dd’ eg ‘2021-03-05’ SELECT * FROM orders WHERE date <= ‘2020-03-28′ Time SQLite stores times as text fields. They must be stored as ‘hh:mm:ss’ SELECT * FROM<\/p>\n
Read More<\/a><\/p>\n","protected":false},"author":7,"featured_media":0,"parent":53,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-46","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/46","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/comments?post=46"}],"version-history":[{"count":8,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/46\/revisions"}],"predecessor-version":[{"id":617,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/46\/revisions\/617"}],"up":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/pages\/53"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/sh\/ahscomputingsql\/wp-json\/wp\/v2\/media?parent=46"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}