SQL select and datetime to date

Is there a way to create a sql select (remote sql server) statement that
brings down a datetime field as a FoxPro date field.

I tried the CAST function:

select cast(mydatetimefield as date) from my table, but apparently sql
server does not understand the 'date' type for the cast function - works in
native - I guess because VFP has a DATE type.

Is there a clean way to get the data this way - I think it is done in emote
views with a command like this:
DBSetProp(ThisView+".mydatetimefield","Field","DataType","D")

How can I do this with a sqlexec stmt.

Thanks,

Happy New Year




.

Relevant Pages

  • Re: 1000 records FlatFile takes over 5 minutes before being publis
    ... I need to debatch 1 file of 1000 records into 1000 seperate records. ... I am still seeing the spool size increasing step by ... We use 1 BizTalk application server with 1 remote SQL server when doing our ...
    (microsoft.public.biztalk.general)
  • Re: Storing only timepart in Sql server datetime
    ... I'm using a DateTime field in MS SQL 2000, and by using Delphi's Frac method ... > stuck with setting up a character data type for the time portion only. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Typed dataset: Time only data in SQL dateTime Field
    ... I can type in a Time alone directly into a sql DateTime field. ... I need to retain the format as it was in access. ... how be able to provide input to my typed dataset to replicate the behavior. ... I also noticed that the Sql import was able to replicate this format. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Information between specific dates
    ... a dateTime field. ... After you answer that perhaps you can post the SQL view of your query. ... Access MVP 2002-2005, 2007-2008 ... Center for Health Program Development and Management ...
    (microsoft.public.access.queries)
  • Re: UPDATING/INSERTING DATETIME FIELDS FROM ASP?
    ... I think I will need to use calculations at some point, is there a way to pass the Nowvalue into the datetime field. ... I would have used the timestamp but it isn't available on my SQL server. ... Please reply to the newsgroup. ...
    (microsoft.public.inetserver.asp.db)