SQL Server Date/Time Field Type

SQL Server Date/Time Field Type

Post by Jerge » Tue, 10 Nov 1998 04:00:00



I am creating an Access database which, at some time, will be migrated to a
SQL Server database.  I have some date/time fields which are used as record
timestamps with both a date and a time field (general date format).  Does
SQL Server have this combined field type like Access, or does it store them
separately (1 field date, 1 field time)?

Are there any reasons not to use the combined date/time field?

Thanks in advance.

 
 
 

SQL Server Date/Time Field Type

Post by Tom Hummel, International Superst » Tue, 10 Nov 1998 04:00:00


SQL Server does have a datetime data type. If both portions are
significant, I don't see a reason not to use the datetime type.

        -Tom.


>I am creating an Access database which, at some time, will be migrated to a
>SQL Server database.  I have some date/time fields which are used as record
>timestamps with both a date and a time field (general date format).  Does
>SQL Server have this combined field type like Access, or does it store them
>separately (1 field date, 1 field time)?

>Are there any reasons not to use the combined date/time field?

>Thanks in advance.



 
 
 

1. MySQL ODBC - Coverting Access date/time type to MySQL date/time type

All

Has anyone had the following problem with the MySQL ODBC (& hopefully
have a solution!):

When uploading tables from a Access '95 database to a MySQL database the
date/time type in Access become muddled! I have sent the data up in
dd/mm/yy format & yyyy-mm-dd format but the information comes out with
additional digits (e.g., '1998-12-14' comes out as '00:00:00 1998-12-14'
or the time 22:45:10 comes out with nn:nn:nn 22:45:10 (were 'n' is a
digit which depends on the time uploaded!)).

HELP!

Regards

2. Importing an IP address converts to Money

3. SQL data type for Microsoft Access time and date fields

4. Paradox 7 Mailing Labels Expert problems

5. Feature-request: allowing the date/time type to accept ISO8601 compliant date/time combinations on input

6. create database error/bug?

7. Insert Date type variable through ODBC SQL Server Driver to datetime field in SQL 7.0 DB

8. TEST

9. java.sql.Date, Time, and TimeStamp with Oracle date type

10. Date time types in SQL Server

11. java.sql.Date producing a time element when passed to SQL Server datetime field

12. To add a field of the type Dates with a field of the Whole type

13. how to change dates or times in a oracle date time field