Send to Database component RRTs
Component RRT ID
The RRT ID for this component is SDB.
Reserved Replacement Tag Names (RRTN)
The following table describes the reserved RTN values.
| RRTN | Description |
|---|---|
| FileName | The original file name value. |
| FileExt | The original file extension value. |
| FileSize | The size of the file in bytes. |
Special Set Replacement Tag Names (SSRTN)
This component supports the Date/Time tag names listed below:
| SSRTN | Description |
|---|---|
| %a | Abbreviated weekday name |
| %a | Full weekday name |
| %b | Abbreviated month name |
| %B | Full month name |
| %d | Day of month as decimal number (01 – 31) |
| %H | Hour in 24-hour format (00 – 23) |
| %I | Hour in 12-hour format (01 – 12) |
| %j | Day of year as decimal number (001 – 366) |
| %m | Month as decimal number (01 – 12) |
| %M | Minute as decimal number (00 – 59) |
| %p | Current locale’s A.M./P.M. indicator for 12-hour clock |
| %S | Second as decimal number (00 – 59) |
| %U | Week of year as decimal number, with Sunday as first day of week (00 – 53) |
| %w | Weekday as decimal number (0 – 6; Sunday is 0) |
| %W | Week of year as decimal number, with Monday as first day of week (00 – 53) |
| %y | Year without century, as decimal number (00 – 99) |
| %Y | Year with century, as decimal number |
Date and time related RRTs are evaluated in Coordinated Universal Time
(UTC) by default. It can be set to use local time, for more details, see Using RRTs.
An example using a SSRTN:
The RRT expression ~SDB::%m~-~SDB::%d~-~SDB::%Y~ will be replaced by “07-23-2005”.