如何使用oracle的基本日期选择器搜索日期？ [英] how to search a date by using basic date picker for oracle ?

问题描述

我正在使用vb.net和oracle作为我的数据库

我将如何使用我指定为bdp1的基本日期选择器搜索一天的日期？



这是我的基本代码

i'm using vb.net and oracle as my database
how i'm going to search a date for a day only by using basic date picker which i assign as bdp1 ?

this is my basic code

Private Function GetDate( ByVal bdp1 As date) As DataSet

        Dim connectionString As String = "Data Source = abc; User ID = ***; Password = ***;"
        Dim sqlConnection As OracleClient.OracleConnection = New OracleClient.OracleConnection(connectionString)


        Dim queryString As String = "select * from table_abc where (column_name<= to_date( 'user_input' ,'MM/DD/YYYY') and column_name > to_date( 'user_input' ,'MM/DD/YYYY')

        Dim sqlCommand As OracleClient.OracleCommand = New OracleClient.OracleCommand(queryString, sqlConnection)
        sqlCommand.CommandTimeout = 0

        sqlCommand.Parameters.Add(New OracleParameter(":bdp1", OracleType.DateTime)).Value = bdp1


        Dim dataAdapter As OracleClient.OracleDataAdapter = New OracleClient.OracleDataAdapter(sqlCommand)
        Dim dataSet As DataSet = New DataSet
        dataAdapter.Fill(dataSet)

        Return dataSet

    End Function

推荐答案

在此初始以整数格式保存日期（如果日期是03/04/2013，则将其保存为20130403）。之后您使用了以下代码之间的代码您将得到它



















来自MSTPATINDX M的SELECT M.REGNO在什么地方之间'和'frmdate&''AND'&todate&'

In this initially save the date in a integer format like ( if date is 03/04/2013 then save it as 20130403). after then you used the between like below code You will get it









SELECT M.REGNO FROM MSTPATINDX M WHERE M.ADMNDATE BETWEEN '" & frmdate & "' AND '" & todate & "'

这篇关于如何使用oracle的基本日期选择器搜索日期？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！