How to determine the format of a field in a table using sql? [closed]
I am attempting to create a table using sql. I want the "dollars" field to show up as currency in this format: $0.00. Using the the following command I can only get the format without the dollar sign.
CREATE TABLE "mytable3" ("id" INTEGER PRIMARY KEY, "dollars" NUMERIC (10,2))