MS SQL Server New Users - Pulling information from Views

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Pulling information from Views

Topper

2005-04-14, 1:23 pm

I am trying to pull information from SQL 2000 on the Create_Date and seem to
be getting in accurate results. It seems as though even though I will use the
current date for ex. 04142005 it converts it into 1113502392 in the view.
How can I query to get the results I need?

Jacco Schalkwijk

2005-04-15, 11:23 am

Can you post the exact query and your table definitions? (See
www.aspfaq.com/5006)

--
Jacco Schalkwijk
SQL Server MVP

"Topper" <Topper@discussions.microsoft.com> wrote in message
news:D991BA35-BD7B-410C-82BD- FA8583AD96BC@microso
ft.com...
>I am trying to pull information from SQL 2000 on the Create_Date and seem
>to
> be getting in accurate results. It seems as though even though I will use
> the
> current date for ex. 04142005 it converts it into 1113502392 in the
> view.
> How can I query to get the results I need?

Sponsored Links