Click here to Skip to main content
16,016,814 members
Home / Discussions / Visual Basic
   

Visual Basic

 
AnswerRe: Connection string for Integrated Security Pin
Dave Kreskowiak14-Oct-20 17:04
mveDave Kreskowiak14-Oct-20 17:04 
GeneralStar Rating In Microsoft Outlook 2016 Pin
Member 1341109113-Oct-20 21:07
Member 1341109113-Oct-20 21:07 
QuestionInsert timestamp using datareader to oracle date Pin
kerek25-Oct-20 18:16
kerek25-Oct-20 18:16 
AnswerRe: Insert timestamp using datareader to oracle date Pin
Richard Deeming5-Oct-20 21:26
mveRichard Deeming5-Oct-20 21:26 
AnswerRe: Insert timestamp using datareader to oracle date Pin
Victor Nijegorodov5-Oct-20 21:40
Victor Nijegorodov5-Oct-20 21:40 
AnswerRe: Insert timestamp using datareader to oracle date Pin
DerekT-P5-Oct-20 22:31
professionalDerekT-P5-Oct-20 22:31 
GeneralRe: Insert timestamp using datareader to oracle date Pin
kerek26-Oct-20 3:50
kerek26-Oct-20 3:50 
GeneralRe: Insert timestamp using datareader to oracle date Pin
kerek27-Oct-20 15:37
kerek27-Oct-20 15:37 
Ok sir thank for the idea it's done by this
<pre>  Dim touch As String = DateTime.Now.ToString("dd-MM-yyyy hh:mm:ss tt")
                        touch = ("" & IBSSDR.Item("EVENTDATE").ToString & "")

                        oracmd.CommandText = "INSERT INTO ASIS.TIMECLOCK_DATA(TD_CARDHOLDER_ID,TD_EVENT_DATE,TD_FIRST_IN,TD_IN_READER,TD_IP_CONTROLLER,TD_TYPE) " & _
                                             " VALUES  ('" & IBSSDR.Item("CARDHOLDERID") & "',TO_DATE('" & touch & "','dd/mm/yyyy hh:mi:ss am')," & _
                                            "TO_DATE('" & touch & "','dd/mm/yyyy hh:mi:ss am'),'" & IBSSDR.Item("DEVICEID") & "','" & IBSSDR.Item("WINSOCKIPADDRESS") & "','CHECKIN') "

VB





Thank you for yuor help Wink | ;) Wink | ;)
GeneralRe: Insert timestamp using datareader to oracle date Pin
Dave Kreskowiak7-Oct-20 17:58
mveDave Kreskowiak7-Oct-20 17:58 
GeneralRe: Insert timestamp using datareader to oracle date Pin
kerek226-Oct-20 20:27
kerek226-Oct-20 20:27 
GeneralRe: Insert timestamp using datareader to oracle date Pin
Richard Deeming26-Oct-20 22:19
mveRichard Deeming26-Oct-20 22:19 
GeneralRe: Insert timestamp using datareader to oracle date Pin
kerek227-Oct-20 13:47
kerek227-Oct-20 13:47 
GeneralRe: Insert timestamp using datareader to oracle date Pin
Dave Kreskowiak27-Oct-20 6:48
mveDave Kreskowiak27-Oct-20 6:48 
GeneralRe: Insert timestamp using datareader to oracle date Pin
kerek227-Oct-20 16:32
kerek227-Oct-20 16:32 
GeneralRe: Insert timestamp using datareader to oracle date Pin
Dave Kreskowiak27-Oct-20 18:27
mveDave Kreskowiak27-Oct-20 18:27 
GeneralRe: Insert timestamp using datareader to oracle date Pin
kerek229-Oct-20 14:11
kerek229-Oct-20 14:11 
GeneralRe: Insert timestamp using datareader to oracle date Pin
Dave Kreskowiak29-Oct-20 14:13
mveDave Kreskowiak29-Oct-20 14:13 
GeneralRe: Insert timestamp using datareader to oracle date Pin
Victor Nijegorodov27-Oct-20 21:11
Victor Nijegorodov27-Oct-20 21:11 
GeneralRe: Insert timestamp using datareader to oracle date Pin
DerekT-P7-Oct-20 23:39
professionalDerekT-P7-Oct-20 23:39 
GeneralRe: Insert timestamp using datareader to oracle date Pin
kerek211-Oct-20 17:14
kerek211-Oct-20 17:14 
QuestionCreate an assignment operator that accepts as const value: CLOSED Pin
mo149230-Sep-20 5:36
mo149230-Sep-20 5:36 
Questionselect MIN(Date) value and other data from multiple table Pin
kerek228-Sep-20 22:46
kerek228-Sep-20 22:46 
SuggestionRe: select MIN(Date) value and other data from multiple table Pin
Richard Deeming29-Sep-20 0:10
mveRichard Deeming29-Sep-20 0:10 
GeneralRe: select MIN(Date) value and other data from multiple table Pin
kerek230-Sep-20 21:17
kerek230-Sep-20 21:17 
GeneralRe: select MIN(Date) value and other data from multiple table Pin
Richard Deeming30-Sep-20 22:03
mveRichard Deeming30-Sep-20 22:03 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.