Creates a column object representing an DateTimeOffset datatype.
New-DateTimeOffsetColumn [-Name] <String> [[-Precision] <Int32>] [-Sparse] [-Default <String>] [-Description <String>] [<CommonParameters>]
New-DateTimeOffsetColumn [-Name] <String> [[-Precision] <Int32>] -NotNull [-Default <String>] [-Description <String>] [<CommonParameters>]
Use this function in the Column
script block for Add-Table
:
Add-Table 'Orders' {
DateTimeOffset 'OrderedAt'
}
Name | Type | Description | Required? | Pipeline Input | Default Value |
---|---|---|---|---|---|
Name | String | The column's name. |
true | false | |
Precision | Int32 | The number of decimal digits that will be stored to the right of the decimal point |
false | false | 0 |
NotNull | SwitchParameter | Don't allow |
true | false | False |
Sparse | SwitchParameter | Store nulls as Sparse. |
false | false | False |
Default | String | A SQL Server expression for the column's default value |
false | false | |
Description | String | A description of the column. |
false | false |
Add-Table 'Orers' { DateTimeOffset 'OrderedAt' }
Demonstrates how to create an optional datetimeoffset
column.
Add-Table 'Orders' { DateTimeOffset 'OrderedAt' 5 -NotNull }
Demonstrates how to create a required datetimeoffset
column with a digits of fractional seconds precision.
Add-Table 'Orders' { DateTimeOffset 'OrderedAt' -Sparse }
Demonstrate show to create a nullable, sparse datetimeoffset
column when adding a new table.
Add-Table 'Orders' { DateTimeOffset 'OrderedAt' -NotNull -Default 'getutcdate()' }
Demonstrates how to create a datetimeoffset
column with a default value. You only use UTC dates, right?
Add-Table 'Orders' { DateTimeOffset 'OrderedAt' -NotNull -Description 'The time the record was created.' }
Demonstrates how to create a datetimeoffset
column with a description.