Home / Questions / 490795
Accepted
yiha
Asked: 2022-03-16 06:26:50 +0800 CST 2022-03-16 06:26:50 +0800 CST

Convert number to sqlite text

  • 772

I am doing a query to a sqlite database so that it returns the trackid, song and duration but they ask me for the duration to be short, medium or long depending on the number, I can get the trackid, the songs and the durations but I do not get that the duration field which is an int is displayed as a text string

I am executing the following query:

SELECT TrackId, Name as [cancion], Milliseconds as [duracion] FROM tracks;

And it gives me this: enter image description here

I try to use select cast(Milliseconds as text) from tracks;but it returns empty

Any ideas??

Thanks in advance

sqlite

1 Answers

  1. Best Answer

    You can do this:

    SELECT TrackId, Name as [cancion], 
CASE
WHEN [duracion] < 120000 THEN 'corta' 
WHEN [duracion] < 30000 THEN 'media' 
ELSE 'larga'
END AS duracion FROM tracks;

    The CASE is the same as an IF within a query

    • 0