SQL code to select data for TODAY

#1

I am trying to code a DTS export package to select records from a table where
the significant date field is a CHAR length of 8 variable. The values are
like '20051027'. I want to code a SQL statement to select all records for the
current (system) date.
--
Stan Gosselin

#2

select * from table where field = convert(char,getdate(),112)

http://sqlservercode.blogspot.com/

"Stan" wrote:

Quote:

I am trying to code a DTS export package to select records from a table where
the significant date field is a CHAR length of 8 variable. The values are
like '20051027'. I want to code a SQL statement to select all records for the
current (system) date.
--
Stan Gosselin

#3

Hello SQL,

I would probably use a slight variation of this

select * from table where field = convert(char(8),getdate(),112)

The reason being that the length of the "unlengthed" is 30

select DATALENGTH(convert(char,getdate(),112))

Allan

Quote:

select * from table where field = convert(char,getdate(),112)

http://sqlservercode.blogspot.com/

"Stan" wrote:

I am trying to code a DTS export package to select records from a
table where
the significant date field is a CHAR length of 8 variable. The
values are
like '20051027'. I want to code a SQL statement to select all records
for the
current (system) date.
--
Stan Gosselin

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL code to select data for TODAY

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

SQL code to select data for TODAY - 10-27-2005 , 04:39 PM

RE: SQL code to select data for TODAY - 10-28-2005 , 03:40 AM

RE: SQL code to select data for TODAY - 10-29-2005 , 04:55 AM