I just started to work with sql server 2000. I want to write a query
against "datetime" columns in the sql server 2000 database. I am to be
able to do the following with the sql server 2000 "datetime" columns:
1. Be able to access the date portion only.
2. Be able to access the time portion only.
3. Be able to access only a portion of the date like the month and/or
year only.
4. Be able to access only a portion of the time like the milliseconds
and/or the minutes.
What kind of query statements would I need to write, to be able to
query question ... I just started to work with sql server 2000. ... against "datetime" columns in the sql server 2000 database. ... Be able to access the date portion only. ... What kind of query statements would I need to write, ... (microsoft.public.sqlserver.fulltext)
Re: sql server 2000 ... >I just started to work with sql server 2000. ... > against "datetime" columns in the sql server 2000 database. ... Be able to access the date portion only. ... Be able to access the time portion only. ... (microsoft.public.sqlserver.mseq)
datetime query with parameters problem ... When I create a parameter query in Access ’02 against two datetime... the user for start and end/date and time, and the datasource is in SQL Server... No matter what I do, if I prompt for start and end TIME, it always ... (microsoft.public.access.queries)
Re: query question ... Looking for a SQL Server replication book?... > against "datetime" columns in the sql server 2000 database. ... Be able to access the date portion only. ... > What kind of query statements would I need to write, ... (microsoft.public.sqlserver.fulltext)
Get and update only Time part from DateTime data type field ... Can you give me a SQL syntax or query to select only 'Time' portion from a ... table column which is defined as 'datetime'.... (8 char length) ... (microsoft.public.sqlserver.programming)
