DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: time part of datefield

  1. 05-31-2006, 01:18 AM #1
    itrat
    itrat is offline Junior Member
    Join Date
    Apr 2006
    Posts
    4

    time part of datefield

    Hi ,
    i have a table having below mentioned structure
    name dated
    marry 16/02/2005 07:15:00
    tom 31/01/2005 14:38:14
    John 13/02/2005 07:15:00

    I want to extract the the names that have time of 07:15:00 only .i.e a query should extract only marry,john..
    Please help
    Reply With Quote Reply With Quote
  2. 05-31-2006, 03:36 AM #2
    tabreaz
    tabreaz is offline Senior Member
    Join Date
    Sep 2005
    Posts
    278
    select * from dated
    where to_char(col2, 'HH24:MI:SS') = '17:15:00'
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width