Click here to Skip to main content
15,900,906 members
Home / Discussions / Database
   

Database

 
GeneralRe: postgresql database issues Pin
Member 1191972222-Sep-15 21:35
Member 1191972222-Sep-15 21:35 
GeneralRe: postgresql database issues Pin
Richard MacCutchan23-Sep-15 2:23
mveRichard MacCutchan23-Sep-15 2:23 
GeneralRe: postgresql database issues Pin
Member 1191972223-Sep-15 19:34
Member 1191972223-Sep-15 19:34 
GeneralRe: postgresql database issues Pin
Richard Deeming24-Sep-15 1:55
mveRichard Deeming24-Sep-15 1:55 
GeneralRe: postgresql database issues Pin
Member 1191972225-Sep-15 1:01
Member 1191972225-Sep-15 1:01 
GeneralRe: postgresql database issues Pin
Member 1191972222-Sep-15 0:08
Member 1191972222-Sep-15 0:08 
GeneralRe: postgresql database issues Pin
Member 1191972222-Sep-15 0:20
Member 1191972222-Sep-15 0:20 
AnswerRe: postgresql database issues Pin
Tim Carmichael22-Sep-15 2:31
Tim Carmichael22-Sep-15 2:31 
Read the entire thread to date.

If you run JUST the select:

Member 11919722 wrote:
select dt_bill_date from sc_bill where sc_bill.st_bill_no=sc_bill_details.st_bill_no and dt_bill_date>='1-7-2015'


what values do you get? Do you get a record with a NULL date?
SuggestionRe: postgresql database issues Pin
Richard Deeming22-Sep-15 4:45
mveRichard Deeming22-Sep-15 4:45 
GeneralRe: postgresql database issues Pin
Tim Carmichael22-Sep-15 5:08
Tim Carmichael22-Sep-15 5:08 
GeneralRe: postgresql database issues Pin
Member 1191972222-Sep-15 19:52
Member 1191972222-Sep-15 19:52 
GeneralRe: postgresql database issues Pin
Member 1191972222-Sep-15 19:59
Member 1191972222-Sep-15 19:59 
GeneralRe: postgresql database issues Pin
Member 1191972222-Sep-15 19:50
Member 1191972222-Sep-15 19:50 
QuestionMigrate data from Mysql Server to Sql Server Pin
Member 1199919920-Sep-15 21:10
Member 1199919920-Sep-15 21:10 
QuestionSearching with desired column name with value is not working Pin
Member 1179609715-Sep-15 21:47
Member 1179609715-Sep-15 21:47 
AnswerRe: Searching with desired column name with value is not working Pin
Corporal Agarn16-Sep-15 0:40
professionalCorporal Agarn16-Sep-15 0:40 
GeneralRe: Searching with desired column name with value is not working Pin
Member 1179609716-Sep-15 1:06
Member 1179609716-Sep-15 1:06 
GeneralRe: Searching with desired column name with value is not working Pin
GuyThiebaut16-Sep-15 1:13
professionalGuyThiebaut16-Sep-15 1:13 
GeneralRe: Searching with desired column name with value is not working Pin
Richard Deeming16-Sep-15 2:33
mveRichard Deeming16-Sep-15 2:33 
GeneralRe: Searching with desired column name with value is not working Pin
Corporal Agarn16-Sep-15 1:18
professionalCorporal Agarn16-Sep-15 1:18 
GeneralRe: Searching with desired column name with value is not working Pin
Richard Deeming16-Sep-15 2:34
mveRichard Deeming16-Sep-15 2:34 
GeneralRe: Searching with desired column name with value is not working Pin
Corporal Agarn16-Sep-15 2:48
professionalCorporal Agarn16-Sep-15 2:48 
GeneralRe: Searching with desired column name with value is not working Pin
Richard Deeming16-Sep-15 2:40
mveRichard Deeming16-Sep-15 2:40 
QuestionHow to find a stored procedure by Author's HostName or LoginName Pin
Mphirana15-Sep-15 2:42
Mphirana15-Sep-15 2:42 
AnswerRe: How to find a stored procedure by Author's HostName or LoginName Pin
Eddy Vluggen15-Sep-15 4:51
professionalEddy Vluggen15-Sep-15 4:51 

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.