python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - varchar

Why is my professor saying storing Dates as Dates are incorrect?(Varchar)

I am taking a course at a public uni in the US. Currently, we are learning databases(mySQL) where we are storing dates in ISO format: (2020-01-29), I was originally storing them as Dates, because I as...
test-img

James Radcliff

mysql

varchar

Votes: 0

Answers: 0

Convert Varchar date format from yyyy-MM-dd to yyyyMMdd in SQL

Hi I am trying to convert Varchar date format from yyyy-MM-dd to yyyyMMdd in SQL.I tried the below approaches but nothing is working. Declare @doj VARCHAR(10) Set @doj='2022-01-01' Select convert (VA...
test-img

learner123

sql-server

date

sql-server-2016

varchar

Votes: 0

Answers: 2

Latest Answer

You can just convert to datetime and back again using explicit style numbers: Declare @doj VARCHAR(10) = '2022-01-01'; SELECT CONVERT(varchar(10), CONVERT(datetime, @doj, 126), 112); db<>fiddle...
test-img

Charlieface

From Varchar to Nvarchar with &#39;N&#39; prefix

I have a table with thousands of rows. One of the columns does not read the values correctly. Some letters cannot be recognised and thus changed to some symbols like in the attached screenshot. I foun...
test-img

Farkhod Giyasov

sql

oracle

varchar

nvarchar

Votes: 0

Answers: 1

Latest Answer

CREATE TABLE fg_test_geo( budesland VARCHAR(30) ,nbudesland NVARCHAR(30) ); INSERT INTO fg_test_geo(budesland,nbudesland) VALUES ('bucurești',N'bucurești'); We could alter the existing varch...
test-img

Paul Maxwell

Loopback 4 - Is it possible to define id property&#39;s length?

Using LB4 + MySQL DB through loopback-connector-mysql to create tables on DB. A {id: string, name: string} id names 0007bc40-814b-11ec-8128-4df48bd1ae4d John 0007bc40-814b-11ec-8128-4df48bd1...
test-img

Alex Corregidor

mysql

indexing

loopbackjs

varchar

loopback4

Votes: 0

Answers: 1

Latest Answer

this works for me.. I prefer to use fixed char guid - old habits ;) //// For ID (Primary key) @property({ type: 'string', id: true, defaultFn: 'uuidv4', dataType: 'char', limit: 36, }) id?: ...
test-img

Gagan

Posts

Questions

Blogs

Jobs