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.

“Every language has an optimization operator. In C++ that operator is ‘//’”