python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - rdbms

How to check TIMESTAMP format in SQL?

What's the best way to check if the VARIANT TYPE with JSONs with value similar to TIMESTAMP_NTZ has correct format? For example, this is the correct format that I would like to have 2020-12-26T12:12:...
test-img

Tims

sql

timestamp

rdbms

Votes: 0

Answers: 2

Latest Answer

If all the records you want to detect come in addition to the end of the format that should be then you can use length. Basically: WHERE NOT len(column_name)=27 27 because your correct format 2020-12...
test-img

Eren Temelli

Getting data from Cassandra tables to MongoDB/RDBMS in realtime

I have an application which is using Cassandra as a database.I need to create some kind of reports from the Cassanbdra DB data, but data is not modelled as per report queries. So one report may have d...
test-img

user2974954

python

cassandra

mongodb-query

pipeline

rdbms

Votes: 0

Answers: 1

Latest Answer

You would be better off using spark + spark cassandra connector combination to do this task. With Spark you can do joins in memory and write the data back to Cassandra or any text file.
test-img

Manish Khandelwal

does sqllite work well in pos desktop application

I'm currently working on a desktop POS application using flutter and the application does not necessarily need an internet connection or networking at all it works locally I have choosen sqlite (sqfli...
test-img

Karrar

flutter

sqlite

rdbms

desktop

sqflite

Votes: 0

Answers: 0

How to deal with a directory that has a space in it being passed to ProcessBuilder and then to Exp.exe?

I am working on an issue where spaces in a directory cause a program that runs exp.exe to crash. The user first selects a .dmp file from any directory they want, which is then used to build an argumen...
test-img

binarycoffee356

java

file

directory

rdbms

processbuilder

Votes: 0

Answers: 1

Latest Answer

Spaces in file or directory names have to escape by \! String file = "C:\Users\Me\OneDrive - Folder\Desktop\test\log.dmp"; file = file.replaceAll(" ", "\\ "); The doubl...
test-img

Thilo Schwarz

Posts

Questions

Blogs

Jobs