Click here to Skip to main content
16,021,988 members
Home / Discussions / Database
   

Database

 
GeneralRe: WITSML Server And Client in C# Pin
Member 1332584614-Feb-21 22:53
Member 1332584614-Feb-21 22:53 
Generalneed website to create database Pin
Member 150643285-Feb-21 12:51
Member 150643285-Feb-21 12:51 
QuestionRe: need website to create database Pin
Eddy Vluggen5-Feb-21 13:09
professionalEddy Vluggen5-Feb-21 13:09 
GeneralRe: need website to create database Pin
RickZeeland5-Feb-21 20:19
mveRickZeeland5-Feb-21 20:19 
AnswerRe: need website to create database Pin
Slacker0076-Feb-21 2:33
professionalSlacker0076-Feb-21 2:33 
GeneralRe: need website to create database Pin
dandy726-Feb-21 3:16
dandy726-Feb-21 3:16 
GeneralRe: need website to create database Pin
Gerry Schmitz6-Feb-21 9:31
mveGerry Schmitz6-Feb-21 9:31 
QuestionFirebird : SQL to Get record today only Pin
kerek221-Jan-21 15:12
kerek221-Jan-21 15: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 22:05
mveRichard MacCutchan21-Jan-21 22:05 
GeneralRe: Firebird : SQL to Get record today only Pin
kerek224-Jan-21 13:03
kerek224-Jan-21 13:03 
AnswerRe: Firebird : SQL to Get record today only Pin
Mycroft Holmes22-Jan-21 11:00
professionalMycroft Holmes22-Jan-21 11:00 
AnswerRe: Firebird : SQL to Get record today only Pin
DerekT-P23-Jan-21 8:18
professionalDerekT-P23-Jan-21 8:18 
GeneralRe: Firebird : SQL to Get record today only Pin
kerek224-Jan-21 13:09
kerek224-Jan-21 13:09 
QuestionRe: Firebird : SQL to Get record today only Pin
David Crow12-Mar-21 6:40
David Crow12-Mar-21 6:40 
QuestionSQL Server: Retry update if fail Pin
Mou_kol8-Jan-21 4:22
Mou_kol8-Jan-21 4:22 
AnswerRe: SQL Server: Retry update if fail Pin
Richard Deeming8-Jan-21 4:49
mveRichard Deeming8-Jan-21 4:49 
QuestionSQL Server Difference among ROWLOCK ,UPDLock AND xlock Pin
Mou_kol8-Jan-21 4:19
Mou_kol8-Jan-21 4:19 
AnswerRe: SQL Server Difference among ROWLOCK ,UPDLock AND xlock Pin
Richard Deeming8-Jan-21 4:51
mveRichard Deeming8-Jan-21 4:51 
GeneralRe: SQL Server Difference among ROWLOCK ,UPDLock AND xlock Pin
Mou_kol8-Jan-21 5:01
Mou_kol8-Jan-21 5:01 
GeneralRe: SQL Server Difference among ROWLOCK ,UPDLock AND xlock Pin
Eddy Vluggen26-Jan-21 12:31
professionalEddy Vluggen26-Jan-21 12:31 
QuestionStoring Entity states in DB Pin
kabuto1787-Dec-20 16:31
kabuto1787-Dec-20 16:31 
AnswerRe: Storing Entity states in DB Pin
Richard Deeming7-Dec-20 22:36
mveRichard Deeming7-Dec-20 22:36 
GeneralRe: Storing Entity states in DB Pin
Mycroft Holmes8-Dec-20 10:56
professionalMycroft Holmes8-Dec-20 10:56 
GeneralRe: Storing Entity states in DB Pin
kabuto1789-Dec-20 13:35
kabuto1789-Dec-20 13:35 
QuestionResetting Value of Each User At Once (PHP MYSQLI) Pin
nateola444-Dec-20 22:14
nateola444-Dec-20 22: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.