Pass date to sql query in matlab

Question

I can't figure out how to pass a date to my sql query in matlab. When I do it "statically" it workds perfectly well:

myquery1 = ['Select DeliveryMonth, Value '...
 ' FROM [mydatabase] '...
 ' where idcurve = 33 ' ...
 ' and deliverymonth <''20121130'' '...
  ' order by DeliveryMonth ']

But what I want is this:

breakdate = input('Enter a breakdate as 20121130: ', 's')

myquery1 = ['Select DeliveryMonth, Value '...
 ' FROM [mydatabase] '...
 ' where idcurve = 33 ' ...
 ' and deliverymonth <   ''breakdate'' '...
  ' order by DeliveryMonth ']

regards A

Franck Dernoncourt · Accepted Answer · 2013-10-17 15:57:07Z

1

You are missing a single quote mark:

breakdate = '20121130'
myquery1 = ['Select DeliveryMonth, Value '...
 ' FROM [mydatabase] '...
 ' where idcurve = 33 ' ...
 ' and deliverymonth < '''breakdate''' '...
  ' order by DeliveryMonth ']

which returns:

myquery1 =

Select DeliveryMonth, Value  FROM [mydatabase]  where idcurve = 33  and deliverymonth < '20121130'  order by DeliveryMonth

answered Oct 17, 2013 at 15:57

Franck Dernoncourt

84.7k81 gold badges374 silver badges556 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

oceanfront Over a year ago

checking myquery1 it just retursn ...deliverymonth < 'breakdate'... There must be some conversion problems somewhere.

oceanfront Over a year ago

Ok, so I solved this by using a great GUI from mathworks at mathworks.com/matlabcentral/fileexchange/8313-uigetdate/content/… and then changing my code to myquery1 = ['Select DeliveryMonth, Value '... ' FROM [ENOI_INDICI].[dbo].[v_mdm_MCurves] '... ' where idcurve = 33 '... ' and deliverymonth <',' ''',datestr(breakdate,29),' '''... ' order by DeliveryMonth ']

BTC · Accepted Answer · 2013-10-17 15:34:27Z

0

 ' and deliverymonth < '  + breakdate + ...

answered Oct 17, 2013 at 15:34

BTC

4,1126 gold badges29 silver badges42 bronze badges

1 Comment

oceanfront Over a year ago

Sorry no doesn't work. ahve tried this: ' and deliverymonth <',' ''breakdate '' '... which doesn't give any errors but also does not return any data...

Collectives™ on Stack Overflow

Pass date to sql query in matlab

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related