Re: inserting time values to table


"preeti" <shwethanrao@xxxxxxxxx> a écrit dans le message de news: 1133212908.944838.254270@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
|I tried using to_char too.
| I used the following command.
| Select to_char(start_date) from time_slots;
|
| but again instead of displaying 11:00 AM it is displaying "28-nov-05"
| Do I need to set anything in the database?
|

Could you please read my post.
I said use to_char with same format you used with to_date.
In your query you specify no format so your default one is used
which is 'dd-mon-yy'.

Regards
Michel Cadot


.

Relevant Pages

  • Re: perl with mysql which takes a file as a input that contains the info to create the tables
    ... in the above text format u can find two tables one is Details> & the other ... strings, so you know that it will except a string. ... all you will need to do is shove the create table command in a single string ... Whatever command your string contains is then executed on your database so ...
    (perl.beginners)
  • Net Send command
    ... I manage to send a message to myself using the "Net Send" command, ... following format: ... Now I want to do it across the internet to some users. ... Prev by Date: ...
    (microsoft.public.win32.programmer.messaging)
  • Net Send Command
    ... I manage to send a message to myself using the "Net Send" command, ... following format: ... Now I want to do it across the internet to some users. ... Prev by Date: ...
    (microsoft.public.win32.programmer.networks)
  • Command Wizard Not Working
    ... I have created a database and tried to go in and add a new form. ... Suddenly the command button wizard won't open when I add a button to my ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Opening another mdb file from a command button?
    ... Is it possible to open another mdb file (i.e. close the current database and ... open another) using a command button? ... Prev by Date: ...
    (microsoft.public.access.forms)