Site Menu
- Home
- Products
- NexusDB
- Nexus Quality Suite
- NexusDB Drivers & Connectors
- Nexus Remoting
- Nexus Memory Manager
- Some of our Customers
- Testimonials and use(r)s
- Downloads
- Documentation
- Support
- Pricing & Orders
- About
- Community
- My Nexus
- Recently Updated ...
- Search...
- Site Login
Search
DateTime Types


Syntax
| | | |
DATE TIME TIMESTAMP DATETIME |
Notes
♦ | DATE is a 4 byte type that contains the datetime fields YEAR, MONTH and DAY. |
♦ | TIME is a 4 byte type that contains the datetime fields HOUR, MINUTE and SECOND. |
♦ | TIMESTAMP is a 8 byte type that contains the datetime fields YEAR, MONTH, DAY, HOUR, MINUTE and SECOND. |
♦ | DATETIME is a NexusDB synonym for TIMESTAMP. |
♦ | The time precision of the datetime types is milliseconds, 3 digits following the decimal point in the SECOND datetime field. |
♦ | Two date time values are comparable only if both have the same datetime fields. |
♦ | A datetime value is assignable only to a datetime site having the same datetime fields. |
Conformance
SQL:2003 standard NexusDB extensions |
- - |
Core SQL DATETIME |
Questions? Problems?
- Interested to buy but something put you off?
- Can't find what you're looking for?
- Have a suggestion?
Let us know. If you're having trouble contacting us, please check here.
3x | SLA - Silver (add years in quantity field) | AUD 3,000.00 |
1x | NexusDB AWE DLL (10 installations; binary) | AUD 1,750.00 |
3x | SLA - Gold (add years in quantity field) | AUD 8,000.01 |
1x | Nexus Quality Suite v1 | AUD 490.00 |
3x | SLA - Platinum (add years in quantity field) | AUD 12,000.00 |
1x | The Full Monty Pack | AUD 1,600.00 |
1x | NexusDB Professional Edition | AUD 1,250.00 |
13 Items | Total: AUD 28,090.01 |
(View cart) (Checkout) |
Site Updates
- Nov 19 2023 - 10:34pm
- Nov 9 2023 - 8:55pm
- Jun 6 2023 - 3:12pm
- May 10 2023 - 7:39pm
- Jan 20 2023 - 10:26am