FedSQL Formats

Overview of Formats
General Format Syntax
Using Formats in FedSQL
Validation of FedSQL Formats
FedSQL Format Examples
Using a User-Defined Format
Format Categories
NLS Formats Supported by FedSQL
Formats Supported with the PUT Function, by Category

$BCDEFHIJMNOPQRSTVWYZ

$BASE64Xw. Format
$BINARYw. Format
$CHARw. Format
$HEXw. Format
$OCTALw. Format
$QUOTEw. Format
$REVERJw. Format
$REVERSw. Format
$UPCASEw. Format
$w. Format
BESTw. Format
BESTDw.p Format
BINARYw. Format
COMMAw.d Format
COMMAXw.d Format
Dw.p Format
DATEw. Format
DATEAMPMw.d Format
DATETIMEw.d Format
DAYw. Format
DDMMYYw. Format
DDMMYYxw. Format
DOLLARw.d Format
DOLLARXw.d Format
DOWNAMEw. Format
DTDATEw. Format
DTMONYYw. Format
DTWKDATXw. Format
DTYEARw. Format
DTYYQCw. Format
Ew. Format
EUROw.d Format
EUROXw.d Format
FLOATw.d Format
FRACTw. Format
HEXw. Format
HHMMw.d Format
HOURw.d Format
IEEEw.d Format
JULIANw. Format
MMDDYYw. Format
MMDDYYxw. Format
MMSSw.d Format
MMYYw. Format
MMYYxw. Format
MONNAMEw. Format
MONTHw. Format
MONYYw. Format
NEGPARENw.d Format
NENGOw. Format
OCTALw. Format
PERCENTw.d Format
PERCENTNw.d Format
QTRw. Format
QTRRw. Format
ROMANw. Format
SIZEKw.d Format
TIMEw.d Format
TIMEAMPMw.d Format
TODw.d Format
VAXRBw.d Format
w.d Format
WEEKDATEw. Format
WEEKDATXw. Format
WEEKDAYw. Format
YEARw. Format
YENw.d Format
YYMMw. Format
YYMMxw. Format
YYMMDDw. Format
YYMMDDxw. Format
YYMONw. Format
YYQw. Format
YYQxw. Format
YYQRw. Format
YYQRxw. Format
YYQZw. Format
Zw.d Format
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 23, 2017