Re: date and datetime

From: Anders (anders_at_anders)
Date: 04/13/04

  • Next message: AK: "Re: date and datetime" 
    Date: Tue, 13 Apr 2004 00:19:26 -0700

    The DBSETPROP function for a remote view allows you to specify a different
    data type
     DbSetProp('myview.datecolumn', 'Field', 'DataType','D')
    -Anders

    "Wilson Thomas" <wilson@indomel.com> skrev i meddelandet
    news:407b8b5e$0$28242$afc38c87@news.optusnet.com.au...
    > Friends,
    >
    >
    >
    > I am working with VFP6 on Access 2000 database. In Access I have created a
    > table with a 'date/time' field and format set as "short date". In access
    it
    > displays as date only, not date/time (E.g., 01/01/2004). That's fine.
    >
    >
    >
    > But when I connect from VFP using DSN, it returns the value as date/time.
    > I.e., as "01/01/2004 00:00:00". The SQL I used is "SELECT * FROM <table
    > name>"
    >
    >
    >
    > I need the returned values displayed as "date" not "date/time".
    >
    > In the form I tried with input mask as "99/99/9999" and format as "D", but
    > no use.
    >
    >
    >
    > Any solution?
    >
    >
    >
    > Thanks in advance
    >
    >
    >
    > Wilson
    >
    >

  • Next message: AK: "Re: date and datetime"

    Relevant Pages

    • Re: Problem while migrating data with Memo content from VFP to Oracle
      ... What data type are you using on the oracle side to hold the memo data? ... What data type is VFP mapping that to when it creates the remote view? ...
      (microsoft.public.fox.programmer.exchange)
    • Re: Error importing (or linking to) a Foxpro table
      ... * Change the data type that the field is assigned to when you import it ... using Access 2000 format databases in Access XP when you want to link to a ... VFP table that contains offending data. ... > you attempted to add" (this corresponds to Access Error 3761). ...
      (microsoft.public.access.externaldata)
    • Re: how to gain numbers
      ... dear friends i do know to use Text data type instead of number data type if ... i am not using that field for calculation but dear friends i am using the ... In the second column of the design grid, next to the name, you can select the ... *better* than a Number field in that you can store leading zeros. ...
      (microsoft.public.access.queries)
    • Re: how to refresh objects if a column changes
      ... Look at the INFORMATION_SCHEMA.ROUTINES view and perform a wildcard search ... in the ROUTINE_DEFINITION column for the column name whose data type ... > Hi friends ... this column so that i could modify them to reflect new chnage? ...
      (microsoft.public.sqlserver.programming)
    • Linking to VFP table within VFP application
      ... A customer has both an Access application and a VFP application. ... The most recent attempt involved the "database/app" DSN, ... to the related VFP index table. ... copying the specific data table out of the VFP app and into ...
      (microsoft.public.fox.vfp.dbc)
    • Quantcast