Query by date

oracle United States
  • 10 years ago

    Hi Guys,

    I am using Oracle 9i as backend and  C# ASP.NET 2.0. Could you please help me that how can I find out  list of users who logged in from date 2006/3/5 till 2007/23/2? I am looking for SQL statement for finding the list of logged users within that date. I have column name logged_date with DATE  as datatype in oracle.

    I would appreciate your help.

    thanks

    sthauttam

     

     

  • 10 years ago
    Hi Sthauttam
     This query may solve your problem.




     Select user_name From tblUser Where logged_date between '03/May/2006' And '23/Feb/2007'


    Good Luck

    Regards
    Hari K......





Post a reply

Enter your message below

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“Debugging is twice as hard as writing the code in the first place. Therefore, if you write the code as cleverly as possible, you are, by definition, not smart enough to debug it.” - Brian Kernighan