- Home
- Firebird Tutorial
- DATE - Firebird
DATE - Firebird
|
|
Interview Questions
All Tutorials
Job SearchIn dialect 3, DATE stores the date alone, with no time portion: “date-only.” Storage is a 32-bit signed integer. Storable dates range from January 1, 0001, to December 31, 9999.
In dialect 1, the DATE type is equivalent to a dialect 3 TIMESTAMP. Indeed, when you create a new date column in a dialect 1 database, using isql , a warning will appear informing you that the type has been renamed! SQLTYPE is isc_timestamp.
There is no “date-only” type in dialect 1. To store a dialect 1 type and make it date only, pass a valid date and time literal with ' 00:00:00.0000' in the time portion. Date and time literals are discussed in greater detail in the following sections.
|
|
Firebird Related Tutorials |
|
|---|---|
| MySQL Tutorial | Linux Tutorial |
| Windows 10 Tutorial | Windows 10 Development Tutorial |
Firebird Tutorial
- Server Memory Requirements
- How To Get An Installation Kit
- Linux Kits
- Windows Kits
- Testing Your Installation
- Installing An Embedded Server
- Other Things You Need To Know
- Default Disk Locations
- Network Protocols
- Named Pipes
- Local Access
- Mixed Platforms
- A Network Address For The Server
- Hosts File
- Server Name And Path
- Configuring The Tcp/ip Port Service
- Testing The Connection With Ping
- Database-level Configuration
- Where To Set Environment Variables
- The Firebird Configuration File
- Running Firebird On Linux/unix
- Running Firebird Server On Windows
- Database Aliasing
- Administering Databases
- Introducing Isql
- Client/server Vs. File-served Databases
- Characteristics Of A Client/server Dbms
- Designing For Client/server Systems
- The Role Of The Server
- Operating System Platforms
- Examples Of Topologies
- Databases
- Firebird’s Procedure Language (psql) Programming
- Multi-database Applications
- Server Security
- Database Security
- What Is A Firebird Client?
- The Firebird Client Library
- Application Development In Firebird
- Installing Clients
- Where To Specify Data Types
- Supported Data Types
- Booleans
- Sql “dialects”
- Optional Sql-92 Delimited Identifiers
- Context Variables
- List Of Predefined Date Literals
- Columns In Firebird
- Domains
- Converting Data Types
- Changing Column And Domain Definitions
- Keywords Used For Specifying Data Type
- Operations On Number Types
- Integer Types
- Fixed-decimal (scaled) Types
- Floating-point Data Types
- DATE
- Timestamp
- Time
- Date Literals
- Recognized Date/time Literal Formats
- Pre-defined Date Literals In Firebird
- Implicit Type-casting Of Date/time Literals
- Date And Time Context Variables
- Operations Using Date And Time Values
- Using Cast(..) With Date/time Types
- The Extract( ) Function
- String Essentials
- Character Sets And Collation Sequences
- Blob Types
- Array Types
- Creating A Domain
- Using A Domain In A Column Definition
- Defining A Boolean Domain
- Changing Domain Definitions
- Dropping A Domain
- The Sysdba User And Password
- What Is Data
- Designing A Database
- Schema Scripts
- Physical Storage For A Database
- About Security Access
- Creating A Database
- Single And Multi-file Databases
- Creating A Multi-file Database
- The Database Cache
- Read-only Databases
- Database Shadows
- Database “hygiene”
- Dropping A Database-delete Command
- About Firebird Tables
- Creating Tables In Firebird
- Constraints In Relational Databases
- Integrity Constraints
- Using External Files As Tables
- What Is Altering Tables Statement
- Removing (dropping) A Table
- Temporary Tables In Firebird
- Terminology In Firebird
- The Foreign Key Constraint
- Interaction Of Constraints
- Custom Action Triggers
- Lookup Tables And Your Data Model
- Reference Privileges
- Handling Other Forms Of Relationship
- “object Is In Use” Error
- Limits
- Automatic Vs. User-defined Indexes
- Query Plans
- How Indexes Can Help
- What To Index
- When To Index
- Using Create Index
- Multi-column Indexes
- Inspecting Indexes
- Altering An Index
- Dropping An Index
- Firebird And The Standards
- Sql Statements
- Sql Dialects
- Sets Of Data
- Privileges-grant And Revoke
- The Select Statement
- The Insert Statement
- The Update Statement
- The Delete Statement
- The Execute Statement
- Queries That Call Stored Procedures
- Using Parameters
- Batch Operations
- Dml Operations And State-changing Events
- Expressions
- Predicates
- Symbols Used In Expressions
- Sql Operators
- Considering Null
- Using Expressions
- Function Calls
- Multi-table Query Kinds
- Joining
- Subqueries-select Query
- The Union Operator
- Considerations For Sorting
- General Form Of Order By Clause
- The Group By Clause
- What Is A View?
- Creating Views
- Read-only And Updatable Views
- Modify A View Definition?
- Dropping A View
- Using Views In Sql
- Using Query Plans For Views
- Other Derived Tables
- The Acid Properties
- Context Of A Transaction
- Transactions And Mga
- Transaction “aging” And Statistics
- Concurrency
- Record Versions
- Locking And Lock Conflicts
- The Language Of Transactions
- Starting A Transaction
- Accessing The Transaction Id
- Progress Of A Transaction
- Nested Transactions
- The Logical Context
- Multi-database Transactions
- Pessimistic Locking
- Stored Procedures, Triggers, And Transactions
- Tips For Optimizing Transaction Behavior
- Overview Of Server Code Modules
- About Stored Procedures
- About Triggers
- Psql Language Extensions
- Internals Of The Technology
- Elements Of Procedures And Triggers
- Programming Constructs
- Executable Stored Procedures
- What Are Selectable Stored Procedures?
- Creating Stored Procedures
- Executable Procedures
- What Are The Uses Of Selectable Stored Procedures?
- Procedures For Combined Use
- Changing Stored Procedures
- Dropping Stored Procedures
- Phase, Event, And Sequence
- Phase And Event
- Status
- Creating Triggers
- Special Psql For Triggers
- Updating Other Tables
- Changing Triggers
- Dropping Triggers
- Types Of Exceptions
- Exceptions In Action
- Handling Exceptions In Firebird
- Runtime Exception Messaging
- Error Codes Listing
- Uses Of Events
- Physical Security
- Platform-based Protection
- Execution Of Arbitrary Code
- Wire Security
- Web And Other N-tier Server Applications
- Entering User Credentials
- The Sysdba User
- The Posix Hole
- The Gsec Utility
- Default Security And Access
- Sql Privileges
- Objects
- Users
- Granting Privileges
- Privileges Through Roles
- Granting The Right To Grant Privileges
- Revoking Permissions
- Revoking Grant Authority
- Security Scripts
- Comparing Superserver And Classic Server Architecture
- Parameters Of Firebird Configuration File
- Working With Embedded Server
- External Code Modules
- Configuring External Locations
- Interactive Mode
- Interactive Commands
- General Isql Commands
- Show Commands To Display Metadata
- Set Commands
- Command Mode
- Extracting Metadata
- About Gbak Files
- Running A Backup
- Running A Restore
- Using Gbak With The Firebird Service Manager
- Gbak Error Messages
- Using Gfix
- Sweeping
- Shutting Down A Database - Firebird
- Changing Database Settings
- Data Validation And Repair
- Transaction Recovery
- Shadows
- Summary Of Gfix Switches
- Firebird’s Lock Manager
- The Lock Print Utility
- Lock Configuration Settings
Installation
Network Setup
Configuring Firebird
Operating Basics
Introduction To Client/server Architecture
Firebird Server
Firebird Clients
About Firebird Data Types
Number Types
Date And Time Types
Character Types
Blobs And Arrays
Domains
From Drawing Board To Database
Creating And Maintaining A Database
Tables
Referential Integrity
Indexes
Firebird’s Sql Language
Dml Queries
Expressions And Predicates
Querying Multiple Tables
Ordered And Aggregated Sets
Views
Overview Of Firebird Transactions In
Configuring Transactions
Programming With Transactions
Introduction To Firebird Programming
Developing Psql Modules
Stored Procedures
Triggers
Error Handling And Events
Security In The Operating Environment
Server Protection
Database-level Security
Configuration And Special Features
Interactive Sql Utility (isql)
Database Backup And Restore (gbak)
Housekeeping Tool (gfix)
Understanding The Lock Manager
