Timestamps

Does anyone know how to pull the date and the time from a timestamp
field in msaccess? Here is an example.

8/30/2007 11:53:00 AM

Ultimately, I would like to be able to place the date in one field and
the time in another. i would then like to be able to sort the time.
Any help would be appreciated.

Thanks,
Scott

.

Relevant Pages

  • qx// vs File commands..
    ... and I need to pull the recent three of each of those files to pwd and ... rename them with timestamp.. ...
    (perl.beginners)
  • Re: Can you avoid pulling the primary key ID and tstamp with a bound datagrid
    ... > timestamp in the Select statement to populate the datagrid, ... Yet I have no need for the primary key or timestamp ... > when I pull that data. ... > better technique that does not pull across unused data? ...
    (microsoft.public.dotnet.framework.adonet)
  • Frozen TimeStamps
    ... I have a database in which users update information and ... When I query this data, I use a select query to pull the ... last update (Timestamp) only. ...
    (microsoft.public.access.forms)
  • Can you avoid pulling the primary key ID and tstamp with a bound datagrid
    ... DataGrid, I've noticed that if I do not have the primary key and the ... timestamp in the Select statement to populate the datagrid, ... when I pull that data. ... better technique that does not pull across unused data? ...
    (microsoft.public.dotnet.framework.adonet)