Click here to Skip to main content
15,502,191 members
Home / Discussions / Database
   

Database

 
GeneralRe: WITSML Server And Client in C# Pin
Member 1332584614-Feb-21 23:53
Member 1332584614-Feb-21 23:53 
Generalneed website to create database Pin
Member 150643285-Feb-21 13:51
Member 150643285-Feb-21 13:51 
QuestionRe: need website to create database Pin
Eddy Vluggen5-Feb-21 14:09
professionalEddy Vluggen5-Feb-21 14:09 
GeneralRe: need website to create database Pin
RickZeeland5-Feb-21 21:19
mveRickZeeland5-Feb-21 21:19 
AnswerRe: need website to create database Pin
Slacker0076-Feb-21 3:33
professionalSlacker0076-Feb-21 3:33 
GeneralRe: need website to create database Pin
dandy726-Feb-21 4:16
dandy726-Feb-21 4:16 
GeneralRe: need website to create database Pin
Gerry Schmitz6-Feb-21 10:31
mveGerry Schmitz6-Feb-21 10:31 
QuestionFirebird : SQL to Get record today only Pin
kerek221-Jan-21 16:12
kerek221-Jan-21 16:12 
Hi Sir,

I try to query record from Firebird where to get record today only with this statement :

SQL
<pre>SELECT * FROM EVENT WHERE EVENTDATE >= CAST('NOW' AS DATE)  AND EVENTMSG ='Access Granted' 
 ORDER BY EVENTDATE



Unfortunately the record appear today record and beyond ( next day upward). Can anyone help me to get record by today only.

Tq in advance.
AnswerRe: Firebird : SQL to Get record today only Pin
Richard MacCutchan21-Jan-21 23:05
mveRichard MacCutchan21-Jan-21 23:05 
GeneralRe: Firebird : SQL to Get record today only Pin
kerek224-Jan-21 14:03
kerek224-Jan-21 14:03 
AnswerRe: Firebird : SQL to Get record today only Pin
Mycroft Holmes22-Jan-21 12:00
professionalMycroft Holmes22-Jan-21 12:00 
AnswerRe: Firebird : SQL to Get record today only Pin
DerekT-P23-Jan-21 9:18
professionalDerekT-P23-Jan-21 9:18 
GeneralRe: Firebird : SQL to Get record today only Pin
kerek224-Jan-21 14:09
kerek224-Jan-21 14:09 
QuestionRe: Firebird : SQL to Get record today only Pin
David Crow12-Mar-21 7:40
David Crow12-Mar-21 7:40 
QuestionSQL Server: Retry update if fail Pin
Mou_kol8-Jan-21 5:22
Mou_kol8-Jan-21 5:22 
AnswerRe: SQL Server: Retry update if fail Pin
Richard Deeming8-Jan-21 5:49
mveRichard Deeming8-Jan-21 5:49 
QuestionSQL Server Difference among ROWLOCK ,UPDLock AND xlock Pin
Mou_kol8-Jan-21 5:19
Mou_kol8-Jan-21 5:19 
AnswerRe: SQL Server Difference among ROWLOCK ,UPDLock AND xlock Pin
Richard Deeming8-Jan-21 5:51
mveRichard Deeming8-Jan-21 5:51 
GeneralRe: SQL Server Difference among ROWLOCK ,UPDLock AND xlock Pin
Mou_kol8-Jan-21 6:01
Mou_kol8-Jan-21 6:01 
GeneralRe: SQL Server Difference among ROWLOCK ,UPDLock AND xlock Pin
Eddy Vluggen26-Jan-21 13:31
professionalEddy Vluggen26-Jan-21 13:31 
QuestionStoring Entity states in DB Pin
kabuto1787-Dec-20 17:31
kabuto1787-Dec-20 17:31 
AnswerRe: Storing Entity states in DB Pin
Richard Deeming7-Dec-20 23:36
mveRichard Deeming7-Dec-20 23:36 
GeneralRe: Storing Entity states in DB Pin
Mycroft Holmes8-Dec-20 11:56
professionalMycroft Holmes8-Dec-20 11:56 
GeneralRe: Storing Entity states in DB Pin
kabuto1789-Dec-20 14:35
kabuto1789-Dec-20 14:35 
QuestionResetting Value of Each User At Once (PHP MYSQLI) Pin
nateola444-Dec-20 23:14
nateola444-Dec-20 23:14 

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.